Re: Server just hanging (Copying to tmp table)

[Thomas Deliduka]

I have a site that has over 30,000 products on it. I disabled searching on it because of the problem with the database. It was killing the server every couple of hours!

I used the different query syntaxes on a filter that resulted in a large result (about 350 products) and here's the results.

Inner join: 55.53 seconds
Left join: 12.43 seconds

I found that totally strange since on a smaller site with a smaller set of products the speed increase was the other way around.

I guess I'll never know why but the search continues to be disabled.

Thanks for your help.

I know enough to be dangerous. Thanks for being patient!



Edited 1 time(s). Last edit at 12/15/2005 02:18PM by Thomas Deliduka.