MySQL Forums
Forum List  »  Performance

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Queries that are slow in my code appears to run quickly on my SQL Client
1884
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.