|
In response to
"OK, this SQL query that I just spent the last half hour formatting ... is 277 lines long."
by
Beryllium
|
some details for the SQL people here (if any) ... it takes 123 seconds to run, for *one* criteria set. (I'll have to run it for a few thousand ...)
Posted by
Beryllium (aka grayman)
Jul 10 '09, 15:07
|
most of them will take less time than that, though, the one I'm testing with is just one of the ones with a ton more data to chug through.
It's done in Postgresql.
The "Explain" for it, in pgAdmin3 1.10.0, is 91 lines long.
Explain Line 1 (i.e., the "last step" of the query):
"Limit (cost=1809375.36..1809375.44 rows=30 width=148)"
|