[snip] I have just tried this, but it still takes 1.5sec to run the select... :-( [/snip]
Fabien, 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. 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
