RE: Help with lengthy query? - solved - Now hardware questions

2004-03-29 Thread Jay Drake
Thanks to all who helped me out. It seems I missed an essential AND statement in my query. Including it brought me from 32 seconds to about 1-2 seconds and all seems to be doing fairly well. I'm a little concerned at this point for the work I'm asking the hardware to do. The server currently deal

Help with lengthy query?

2004-03-29 Thread Jay Drake
I am by no means an accomplished MySQL user, and generally deal with rather simple queries having no need for anything particularly complex, until now. I have been working on a query this past week which has tested my abilities and when all is said and done, the query creates a rather hefty load o