MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Queries that are slow in my code appears to run quickly on my SQL Client
Posted by: David Hammond
Date: February 01, 2005 04:32PM

I am having a similar problem and am quite perplexed.

I have a simple static table with approximately 1.5 million rows. There is an index for the complete WHERE clause I am using. When I execute the SQL in SQL Client it runs in less than 10 ms. I have incorporated the SQL into both Perl and Java as both dynamic and prepared statements. Each select takes 5-10 seconds.

Is there something obvious I am missing?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Queries that are slow in my code appears to run quickly on my SQL Client
3252
Mathieu Pichon
January 21, 2005 07:55AM
Re: Queries that are slow in my code appears to run quickly on my SQL Client
1721
Mathieu Pichon
January 21, 2005 11:07AM
Re: Queries that are slow in my code appears to run quickly on my SQL Client
2095
David Hammond
February 01, 2005 04:32PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.