By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,507 Members | 1,200 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,507 IT Pros & Developers. It's quick & easy.

MS SQL Express Advanced vs MS SQL full version vs MySQL

P: n/a
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
Jul 23 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
(wi*******@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, es****@sommarskog.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
Jul 23 '07 #2

P: n/a
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****@sommarskog.sewrote in message
news:Xn**********************@127.0.0.1...
(wi*******@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, es****@sommarskog.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

Jul 23 '07 #3

P: n/a
(wi*******@hotmail.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****@sommarskog.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
Jul 23 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.