Posted by raylopez99 on 07/23/07 08:05

On Jul 22, 5:31 pm, <wipeou...@hotmail.com> wrote:
> 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

I don't know nothing, but I can attest that MS SQL Server is not
compatible with MySQL--lots of commands are different.

For pure speed, I "heard in the street" that Oracle's version of SQL
is faster than MSFT's. But, because MSFT uses a different protocol
for starting and stopping transactions (for multiuser databases,
involving ROLLBACK), it is slower but in theory "more safe" than
Oracle (small victory for MSFT, since usually speed trumps safety).
MySQL also uses the "MSFT" protocol, so is slower than ORCL for
transactions.

MS Express has extensions to SQL but I doubt it will "replace" SQL.
Nor will any proprietary extension of SQL.

I like MS SQL Server 2005 because it is integrated better into my API
(C# using VS2005), but to be honest MySQL extensions for subqueries
are more intutitive for me. But MySQL lags in development to MSFT--
for example versions 4.x did not have Stored Procedures or Views (!).
And, like I say, I don't like the hassle of translating MySQL <--> MS
SQL Server 2005.

If you spend $50 you can get the "developer" version of MS SQL Server
2005; highly recommended and superior to the free version. Spend the
fifty bucks.

Remember, I don't know much about SQL, but these are my newbie
thoughts.

RL

[Back to original message]