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 tha
John Fabiani 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. The size of the tab
On Saturday, August 28, 2010 08:35:07 am Tom Lane wrote:
> John Fabiani 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 statem
