4 messages in com.mysql.lists.bugsRE: Servere performance issue with co...| From | Sent On | Attachments |
|---|---|---|
| Kevin Cowley | 05 May 2004 10:37 | |
| Jeremy Zawodny | 05 May 2004 11:09 | |
| Kevin Cowley | 05 May 2004 11:20 | |
| Sinisa Milivojevic | 05 May 2004 11:27 |
| Subject: | RE: Servere performance issue with compiled (pre-prepared) querie s - they're 50% slower than parsed queries |
|---|---|
| From: | Kevin Cowley (kevi...@alchemetrics.co.uk) |
| Date: | 05/05/2004 11:20:10 AM |
| List: | com.mysql.lists.bugs |
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: kevi...@alchemetrics.co.uk Web: http://www.alchemetrics.co.uk
-----Original Message----- From: Jeremy Zawodny [mailto:Jer...@Zawodny.com] Sent: 05 May 2004 19:09 To: Kevin Cowley Cc: 'sin...@mysql.com'; Bu...@lists.mysql.com 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. **************************************************************************************