On Mon, Jan 20, 2014 at 9:23 AM, Thomas Kellerer <spam_eater@gmx.net> wrote:
Andrew Puschak, 09.12.2013 22:07:
> I've inherited a web service on a Windows server that connects to a > Postgres database. There is a "SELECT * FROM" query below that runs a > long time and appears to happen whenever there is a web service > update. I'd like to eliminate or limit it but I have to find it > first. I have pgBadger set up and logging turned up which is how I > found the query. > > The developer says the query is not in his code and gave me the > source code. It's pasqual. I see the other queries but I don't see > the select * either in the code. He also added logging of the queries > and the SELECT * FROM is missing. Is it possible another query > creates the select * such as the two queries before it shown below?
Maybe a "clever" ORM that re-selects any row that is touched by a DML statement in order to re-retrieve computed columns or generated IDs?
I don't know if there are any Pascal ORMs around, but I know that some ORMs in the Java world to crazy things like that.
Sounds plausible, I'm still not sure what he uses to run the code, he just says its ODBC. Hopefully it doesn't have any more problems since its legacy code that hopefully will be retired.
