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
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.
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.