RE: Servere performance issue with compiled (pre-prepared) querie s - they're 50% slower than parsed queries

I could send you the test program code and the data files, but you'll need
to write your own routines to read them (the data files). 

Basically you'd need to replace our Openfile, Closefile, and ReadRecord
functions with your own. If this is any use to you then drop and affirmative
reply and I'll send them in the morning - I'm off home now.

Kevin Cowley
R&D
 
Tel: 0118 902 9099 (direct line)
Email: [email protected]
Web: http://www.alchemetrics.co.uk

-----Original Message-----
From: Jeremy Zawodny [mailto:[email protected]] 
Sent: 05 May 2004 19:09
To: Kevin Cowley
Cc: '[email protected]'; [email protected]
Subject: Re: Servere performance issue with compiled (pre-prepared) querie s
- they're 50% slower than parsed queries

On Wednesday, May 5, 2004, at 10:38 US/Pacific, Kevin Cowley wrote:

> I've just downloaded the latest snapshot, rebuilt 4.1.2 and re-run the
> tests. The results are below. It looks like the Inserts are now 
> quicker, but
> not by much, but the selects are considerably slower.

Any chance you can share the code you used?

I was planning to something similar soon and not having to [re]write 
the code would obviously save some time.

If not, I understand.

Thanks,

Jeremy


**************************************************************************************
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 Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]