Re: [SQL] Question about slow queries...

2010-05-27 Thread A. Kretschmer
In response to Good, Thomas : > > Hi, > > I have a question about a query that starts out fine and over time > slows to a halt - but only on a webhosted site. Locally it does fine. > > The query is a singleton select (no joins), hitting a table with about > 5,000 records in it. Over time the q

Re: [SQL] Question about slow queries...

2010-05-27 Thread Tom Lane
"Good, Thomas" writes: > I have a question about a query that starts out fine and over time slows to a > halt - but only on a webhosted site. Locally it does fine. > The query is a singleton select (no joins), hitting a table with about > 5,000 records in it. Over time the query slows to a craw

[SQL] Question about slow queries...

2010-05-27 Thread Good, Thomas
Hi, I have a question about a query that starts out fine and over time slows to a halt - but only on a webhosted site. Locally it does fine. The query is a singleton select (no joins), hitting a table with about 5,000 records in it. Over time the query slows to a crawl and I have to dump and