I merely skimmed it, but your comment that you pay the query compilation cost on every request suggests to me that you're not using prepared statements. If you can, you should :-)
Also, MySQL *does* support SPs, from 5.0 onwards or something. You could split into separate modules for pre- and post-5. On Mon, Oct 25, 2010 at 3:38 PM, Patrick Thompson < patrick.thomp...@channelintelligence.com> wrote: > I am running an open source project that provides an abstraction layer over > a number of different stores. I am puzzled by performance numbers I am > seeing between mysql and sql server - a brief discussion is available here > > http://cipl.codeplex.com/wikipage?title=Data%20Provider%20Comparison > > The statistics were generated using mySql 5.1 and Sql Server 2008 on a > machine with the following specs: > > OS Name Microsoft Windows 7 Professional > System Model HP Compaq nc8430 (RB554UT#ABA) > Processor Intel(R) Core(TM)2 CPU T7200 @ 2.00GHz, 2000 > Mhz, 2 Core(s), 2 Logical Processor(s) > Installed Physical Memory (RAM) 4.00 GB > Total Virtual Memory 6.75 GB > Page File Space 3.37 GB > Disk 120GB SSD with 22GB available > > If this isn't the right place to ask this question, can someone point me to > somewhere that is. > > Thanks > > > Patrick > Are you using... > myList<http://www.mylist.com/> - everything you could possibly want (to > buy) > Let me know if you can't find something > > > ________________________________ > The information contained in this email message is considered confidential > and proprietary to the sender and is intended solely for review and use by > the named recipient. Any unauthorized review, use or distribution is > strictly prohibited. If you have received this message in error, please > advise the sender by reply email and delete the message. > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
