|
|
Posted by <wipeout64 on 07/23/07 14:29
Your answers are very helpful! Now a rather niave question: If I pay for a
site to host my application, does that mean I don't have to purchase the
server software and I only need the developer software?
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns997668DB16155Yazorman@127.0.0.1...
> (wipeout64@hotmail.com) writes:
>> I'm planning to transport a desktop application to the web. A spin-off of
>> this application has already been put on the web by another programmer.
>> He
>> used ColdFusion with MS SQL, Access, VC, and Java. It is faster than the
>> desktop application (written in VFP).
>> 1. Can I get the same results using MS SQL Express Advanced and Access
>> for
>> the internet version if used with .net?
>
> Probably. But you could also get worse performance. It's difficult to
> answer, because it depends on how you do the implementation. DB engines
> are extremely powerful tools to make things to really slow if you don't
> do things right.
>
>> 2. Are the select statements limited in power, accuracy, size, etc. for
>> MS
>> SQL Express Advanced when compared to SQL?
>
> Compared to what? If you mean if there are limitations in SQL Express
> vs. the paid-for editions of SQL Server, the answer is, yes, there are
> some limitations, but it is not all likely that you will suffer from
> them.
>
> First of all, the language is the same, so the SELECT statements that
> runs in Enterprise Edition runs in SQL Express too. And there is no
> difference in accuracy, and hardly in size of the statements either.
> There is a difference in database size: with SQL Express, you cannot
> have databases over 4GB in size.
>
> The difference in performance lies in some special optimizer tweaks, like
> considering using indexed view. But for the major bulk of queries,
> query plans and performance are the same.
>
>> 3. If Access will perform poorly, can VFP be used instead with .net? I
>> already know it can't be used with ColdFusion. 4. If MS Express Advanced
>> will not sufficiently replace SQL, will MySQL do the job better?
>
> Those questions are completely beyond the scope for this newsgroup,
> and also beyond my knowledge.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|