MS SQL Express Advanced vs MS SQL full version vs MySQL

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?
2. Are the select statements limited in power, accuracy, size, etc. for MS
SQL Express Advanced when compared to SQL?
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?

Thanks

[Erland Sommarskog]

(wi*******@hotm ail.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, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

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" <es****@sommars kog.sewrote in message
news:Xn******** **************@ 127.0.0.1...

(wi*******@hotm ail.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, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[Erland Sommarskog]

(wi*******@hotm ail.com) writes:

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?

Right. If you only use MS SQL Server to develop your application, but rely
on a web host to run it for you, you can get by with Developer Edition,
which is 50 USD. And, of course, if you are content with the features of
SQL Express, you can let it suffice with that for an even lower bargain.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx