Kevin, I've been using 4.1.1 since it was released and I've never heard of compiled queries. Are you talking about prepared statements? Donny
> -----Original Message----- > From: Kevin Cowley [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 29, 2004 1:35 PM > To: [EMAIL PROTECTED] Mysql. Com > Subject: Why are compiled queries 50% slower than parsed queries > > OK > > I've just been completing some benchmarking comparing compiled queries > (new > in 4.1.1 and above) with standard parsed queries. > > For both INSERT queries "insert into table( col1, col2,col3) > values(?,?,?)" > and SELECT queries "select col1, col2,col3 where col1 between ? and ?" the > compile query is 50% slower > > Parsed :- > > Insert > total average mean mean max min > run records time time time records time time > 0 24851 7.610451 0.000306 0.000239 1008 105588.000000 > 231.000000 > > Select > > run 0 average > query rows time time > 0 61 0.075193 0.007519 > 1 7 0.049296 0.004930 > 2 41 0.092106 0.009211 > 3 9 0.048571 0.004857 > 4 16 0.048425 0.004843 > 5 62 0.092040 0.009204 > 6 6 0.066477 0.006648 > 7 1 0.280004 0.028000 > 8 8 0.047900 0.004790 > 9 4 0.113344 0.011334 > 10 0 0.214862 0.021486 > 11 0 0.140650 0.014065 > 12 1 0.251094 0.025109 > 13 0 0.123815 0.012382 > 14 0 0.133870 0.013387 > 15 6 0.306981 0.030698 > 16 0 0.074054 0.007405 > 17 0 0.095875 0.009588 > 18 1 0.126500 0.012650 > 19 8 0.109567 0.010957 > > > Compiled :- > > Insert > total average mean mean max min > run records time time time records time time > 0 24851 18.224807 0.000733 0.000506 1117 303256.000000 > 438.000000 > > Select > run 0 average > query rows time time > 0 0 0.086140 0.086140 > 1 0 0.062718 0.062718 > 2 0 0.109377 0.109377 > 3 0 0.062499 0.062499 > 4 0 0.062543 0.062543 > 5 0 0.109723 0.109723 > 6 0 0.085447 0.085447 > 7 0 0.132177 0.132177 > 8 0 0.062524 0.062524 > 9 0 0.133001 0.133001 > 10 0 0.526721 0.526721 > 11 0 0.525792 0.525792 > 12 0 0.524818 0.524818 > 13 0 0.133818 0.133818 > 14 0 0.525871 0.525871 > 15 0 0.527045 0.527045 > 16 0 0.085946 0.085946 > 17 0 0.108599 0.108599 > 18 0 0.526602 0.526602 > 19 0 0.119850 0.119850 > > Anyone care to shed some light on this? > > Kevin Cowley > R&D > > Tel: 0118 902 9099 (direct line) > Email: [EMAIL PROTECTED] > Web: http://www.alchemetrics.co.uk > > > > ************************************************************************** > ************ > ALCHEMETRICS LIMITED (ALCHEMETRICS) > Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX > Tel: +44 (0) 118 902 9000 Fax: +44 (0) 118 902 9001 > This e-mail is confidential and is intended for the use of the addressee > only. > If you are not the intended recipient, you are hereby notified that you > must > not use, copy, disclose, otherwise disseminate or take any action based on > this e-mail or any information herein. > If you receive this transmission in error, please notify the sender > immediately by reply e-mail or by using the contact details above and then > delete this e-mail. > Please note that e-mail may be susceptible to data corruption, > interception > and unauthorised amendment. Alchemetrics does not accept any liability > for > any such corruption, interception, amendment or the consequences thereof. > ************************************************************************** > ************ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]