[snip] > How many records do you have in each table? And just how fast do you want > this query to be? 1.5 seconds may be optimal for a query this large. Perhaps > the only thing you could do at this point is beef up your server.
Not that large, I got about 8.000 records in each table. I did put the body out from the news table, so the news table could be small, and news_body which I don't request all the time would be the bigger one. If I do 2 selects, one to fetch info from the news table, and then another one to fetch bodies, it takes much less time, like 0.05 for each request. Did I miss something ? [/snip] You don't say anything about your hardware, which could be a portion of the problem. If you combine the two queries you have a total return time of 1.0 secs, right? The other 0.5 secs (return time varies with time of day, traffic etc.) is probably processing overhead. Why is getting below 1.5 secs so important? Just curious... Jay "We are all apparently 'net' literate, why don't we use it to get the information we need? After all, isn't that what a Google search is all about?" --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
