Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query executed very slow

Status
Not open for further replies.
theflu

theflu

Programmer
Feb 20, 2002
1
RO
I have a problem in a Java based application which works with a MySQL database. Things happens similary with PhpMyAdmin. To execute a query which selects a table with 600 rows it takes 8 seconds. The same query executed in another application, MySQLGui takes 0,1 seconds. It seems that both programs are connected to the database through mysql socket.
Do you know which can be the cause of the delay?!?
 
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
495
EdLentz
EdLentz
trandrus
  • Locked
  • Question
incrementing a column without having to query the db first
Replies
4
Views
169
Chris Miller
Chris Miller
martinkaeser
  • Locked
  • Question
MySQL Query for incrementing field from duplicates in database
Replies
4
Views
168
martinkaeser
martinkaeser
madcelt
  • Locked
  • Question
Select query not showing error but not showing result either
Replies
2
Views
132
madcelt
madcelt
Filip Boga
  • Locked
  • Question
MYSQL Query
Replies
1
Views
131
feherke
feherke

Part and Inventory Search

Sponsor

Back
Top