-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Damien McKenna wrote:
>>The standard demonstration of MySQL's competitiveness with MS-SQL is >>the well-know eWeek article >>(http://www.pcmag.com/article2/0,1759,103972,00.asp) shows that MySQL >>(4.0 in the tests) paced Oracle and simply kicked the butt of >>everything else, with MS-SQL coming in at the bottom. > > One thing - most pro-MySQL benchmarks use the basic MyISAM tables which > don't support newer features like transactions, etc. Once you move to > INNO DB to add those features you start loosing speed. This one didn't, however it does play to the fact that you can specify the table handler to use. The tables in the test that needed fine-grained locks (row level) used InnoDB, whereas those where table locks were appropriate or where no locking was needed, used MyISAM. K. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCnLxVmSWF0pzlQ04RAqntAJ94SSau4fEhMHl8W+JruHRMLo7P0gCeJZK9 2ajtWOlVW/l0pxxUaEKwniI= =XnwK -----END PGP SIGNATURE----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208090 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
