Shawn, I hope my question was not misinterpreted. I was not suggesting that MSSQL was faster. I was merely asking because I thought that might have been a factor in your decision to us mysql. Actually, I am aware that mysql is very popular. I, too, used it about 4 years ago when I worked for a company that asked me to create web based reporting on a zero budget -- yes, I said zero. So what was I forced to use? PHP and mysql. As far as comparing the two, no, I have not. But it's simply because my choice is MSSQL because I use professionally. However, I do understand the need and importance in having mysql. Since it's been about 4 years, I am not up to date on the changes to mysql. I recall reading something that stated mysql was making hugh advances in terms of comparison to the bigger boys -- MSSQL and Oracle. Anyhow, I may be digressing a bit, since this has moved from asp/database to mysql. Mark
"Shawn K. Hall" <[EMAIL PROTECTED]> wrote: Hi Mark, > Ever run a speed/performance diff between SQL > and mySQL using ASP? Have you? ASP is far from the only language I use, and Windows is not the only platform. MySQL can run on all of them and is accessible from every language I've ever wanted or needed database access with, and doesn't have the same implementation limitations that SQL Server does. MySQL code is portable and cross-platform. I have never run into SQL that worked with MySQL (other than mysql-specific administration code) that could not be made to work with every other db platform with minimal or no changes (granted, the back-quote took some getting used to, but it's only one key-press, and that's nice now that I'm used to it). MySQL also provides some simpler administrative shtuff and the library of resources available for MySQL is infinitely larger than MSSQL. A google for mysql (37 million) gets about 3 times the hits as sql server (13 million), and they're free and universally available - they don't require you to pay to read more than the first 4 lines of an article (one of my major pet peeves for industry apps like MSSQL) and the source library for MySQL is all but infinite. I can find code to do something (or find out that it's not possible) inside of ten minutes - try that on SQL Server. The only feature missing from MySQL that MSSQL has that I would use on a consistent basis is triggers, and for what that's worth, I'll make do. Have you ever run a feature/security flaw diff between SQL Server and MySQL? I don't think there has ever been a devastating MySQL-based worm that all but shut down the entire Internet for several days. And frankly, I doubt there ever will be. Regards, Shawn K. Hall http://ReliableAnswers.com/ '// ======================================================== One nation under surveillance. --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
