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 <
> 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
> 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.
> Are you using...
> myList<http://www.mylist.com/> - everything you could possibly want (to
> 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