List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:October 25 2010 1:55pm
Subject:Re: mySql versus Sql Server performance
View as plain text  
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.Thompson@stripped> 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

Thread
mySql versus Sql Server performancePatrick Thompson25 Oct
  • Re: mySql versus Sql Server performanceJohan De Meersman25 Oct
    • RE: mySql versus Sql Server performancePatrick Thompson25 Oct
  • RE: mySql versus Sql Server performanceGavin Towey25 Oct
    • RE: mySql versus Sql Server performancePatrick Thompson25 Oct
      • RE: mySql versus Sql Server performanceGavin Towey25 Oct
        • RE: mySql versus Sql Server performancePatrick Thompson25 Oct
          • RE: mySql versus Sql Server performanceGavin Towey26 Oct
            • RE: mySql versus Sql Server performancePatrick Thompson26 Oct
  • RE: mySql versus Sql Server performancePatrick Thompson25 Oct