RSS

Re: Query on a large table too slow

Please support our MySQL advertiser: Programming Forums

Query on a large table too slow

•

Join Date: Jun 2004

Posts: 37

Reputation: timhysniu is an unknown quantity at this point

Rep Power: 5

Solved Threads: 0

timhysniu

Offline

Light Poster

Re: Query on a large table too slow

Jul 26th, 2007

•

Originally Posted by pritaeas

If you have your indexes set and it's still too slow, you may have to look at the way you're extracting data. Perhaps there is a way to trim your resultset and still get what you want.

In your case I'd try setting an index to ip_from and ip_to combined

Hi there,
thanks for the response. Setting an index combined didn't exactly help much. Can you please give an example on trimming the resultset?

Are you maybe suggesting that I normalize the table to remove excess fields/long varchars from search table? I tried this and this only reduced the wait time from 0.814 s to 0.550 s which is good, but not exactly efficient considering the possible load on server.

Another strategy I used was adding a is_cashed BOOLEAN field. Query against set is_cashed seems to be quick, however, if the record is not in cashed data set then I must use the same old slow query again.

Any ideas?

Basically all I'm trying to do is identify the location of visitors, but having a homepage delay this much is not a good starting point.

Thanks very much,
Tim

DaniWeb Home > Forums > Web Development > Databases > MySQL > Query on a large table...

Re: Query on a large table too slow

Query on a large table too slow

Re: Query on a large table too slow