|
|
Posted by Erland Sommarskog on 07/23/07 08:15
(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]
|