RE: [GENERAL] Large OR query

2001-06-12 Thread Tamsin
o: SELECT maintable.* FROM maintable, temptable WHERE maintable.id = temptable.id; tamsin > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Mitch Vincent > Sent: 12 June 2001 15:25 > To: Zak McGregor; [EMAIL PROTECTED] > Subject: Re: [GENE

RE: [GENERAL] Large OR query

2001-06-12 Thread Jeff Eckermann
I would load the 1000 values into a temporary table, and join on the ID field. I usually find that approach gives much faster results. > -Original Message- > From: Zak McGregor [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 7:42 AM > To: [EMAIL PROTECTED] > Subject: [GENE