Re: Why are compiled queries 50% slower than parsed queries

2004-04-29 Thread Sasha Pachev
Kevin Cowley wrote: 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 ?" t

RE: Why are compiled queries 50% slower than parsed queries

2004-04-29 Thread Donny Simonton
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 "

Why are compiled queries 50% slower than parsed queries

2004-04-29 Thread Kevin Cowley
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