Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

Selecting where id in (list of 1000 ids) [message #1086] Fri, 13 April 2007 03:02  oordopjes Messages: 15 Registered: January 2007 Junior Member Hi, I'm trying to do the following select: SELECT * FROM table WHERE id IN (1,2,3..999,1000); (with other id numbers of course) However, this query takes about 2 seconds. Is there any way to speed this up? Report message to a moderator

	Selecting where id in (list of 1000 ids) By: oordopjes on Fri, 13 April 2007 03:02
	Re: Selecting where id in (list of 1000 ids) By: oordopjes on Sun, 15 April 2007 14:38
	Re: Selecting where id in (list of 1000 ids) By: carpii on Sun, 15 April 2007 18:21
	Re: Selecting where id in (list of 1000 ids) By: oordopjes on Mon, 16 April 2007 15:23
	Re: Selecting where id in (list of 1000 ids) By: toddjnsn on Tue, 27 May 2008 01:59
	Re: Selecting where id in (list of 1000 ids) By: sterin on Mon, 16 April 2007 18:06
	Re: Selecting where id in (list of 1000 ids) By: oordopjes on Tue, 17 April 2007 07:34
	Re: Selecting where id in (list of 1000 ids) By: sterin on Tue, 17 April 2007 12:41
	Re: Selecting where id in (list of 1000 ids) By: oordopjes on Tue, 17 April 2007 14:46
	Re: Selecting where id in (list of 1000 ids) By: JGilbert on Tue, 08 May 2007 15:31
	Re: Selecting where id in (list of 1000 ids) By: sterin on Wed, 18 April 2007 08:50
	Re: Selecting where id in (list of 1000 ids) By: Peter on Fri, 20 April 2007 18:23
	Re: Selecting where id in (list of 1000 ids) By: carpii on Tue, 27 May 2008 02:48
	Re: Selecting where id in (list of 1000 ids) By: toddjnsn on Tue, 27 May 2008 03:07
	Re: Selecting where id in (list of 1000 ids) By: sterin on Tue, 27 May 2008 05:25
	Re: Selecting where id in (list of 1000 ids) By: toddjnsn on Tue, 27 May 2008 07:30
	Re: Selecting where id in (list of 1000 ids) By: ruben on Wed, 25 June 2008 03:16

Previous Topic:	Integer overflow with UNSIGNED INT columns
Next Topic:	More than 400 concurrent small queries

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]