[SQL] a general ? on select performance

2010-08-28 Thread John Fabiani
Hi, In general what are the causes of SQL select statement slow downs - other than the size of the data? I realize this is a broad question but read on please. Here's where I'm coming from: I have program that loops though several thousands of records. The loop contains a select statement

Re: [SQL] a general ? on select performance

2010-08-28 Thread Tom Lane
John Fabiani jo...@jfcomputer.com writes: I have program that loops though several thousands of records. The loop contains a select statement that confirms that I don't have a dup and then inserts a record into a different table. IOW's the statement is checking against a static table.

Re: [SQL] a general ? on select performance

2010-08-28 Thread John Fabiani
On Saturday, August 28, 2010 08:35:07 am Tom Lane wrote: John Fabiani jo...@jfcomputer.com writes: I have program that loops though several thousands of records. The loop contains a select statement that confirms that I don't have a dup and then inserts a record into a different table.