How large is the status table? I would recommend trying to reduce the inital recordset of your largest table with a subquery and then joining the subquery to the other tables. Could you please show me the full query with the table sizes?
Jake Johnson [EMAIL PROTECTED] http://www.plutoid.com On Mon, 16 Jun 2003, George Pitcher wrote: > Hi, > > I'm having intermittent problems with a big query where I grab about 30 > fields from 4 tables. > > I've snipped my query: > > Select ... Status_Msg from Extracts, Transacts, Publisher, Status where ( Transacts.Status=Status.ID and Transacts.Extract_ID=Extracts.ID and Extracts.Pub_ID=Publisher.ID and Transacts.ID=33237 > > It works sometimes, but not always. > > Can anyone suggest a more efficent way (that works) to do this? > > > Cheers > > George in Oxford > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
