Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

mysql speek

May 4, 2002, 10:35 PM
courierb
User (344 posts)
courierb's avatar
May 4, 2002, 10:35 PM
Post #1 of 3
Views: 4356
Shortcut
Quote Reply
mysql speek
when using mysql ( windows version) weather the query speed is very slow in small size db.

in my case. i even could feel the stop while i do a query via a web form. it take 4-10 secound to get infos fetch back. any comment and any way to imporve it? or any problem exist?



Thanks
May 5, 2002, 11:54 AM
Alex
Administrator (9387 posts)
May 5, 2002, 11:54 AM
Post #2 of 3
Views: 4216
Shortcut
Quote Reply
Re: [courierb] mysql speek In reply to
Hi,

Do an "EXPLAIN" on your query to see why it is taking so long:

EXPLAIN SELECT * FROM Table;

etc.

Cheers,

Alex
--
Gossamer Threads Inc.
May 15, 2002, 5:54 PM
courierb
User (344 posts)
courierb's avatar
May 15, 2002, 5:54 PM
Post #3 of 3
Views: 4114
Shortcut
Quote Reply
Re: [Alex] mysql speek In reply to
Dear Alex.

The problem is only exist when the connection is from remote, while local speed is normal.

any clue?



Thanks