Re:Let Postgres Do the Work (2013)
by phereford on Saturday November 26, 2016 @03:54PM
(#13045792)
That's exactly what we did. We return an anonymous table of records in Postgres that are then passed to ruby to render an excel file. The SQL query takes 27s on average. The ruby view generation is fast as well but I haven't profiled that part of the report.
[ Parent
| on HN ]
> That's exactly what we did. We return an anonymous table of records in Postgres that are then passed to ruby to render an excel file. The SQL query takes 27s on average. The ruby view generation is fast as well but I haven't profiled that part of the report.
What's an "anonymous table of records"? Do you mean it's just a result set (i.e. query)?
Yea. It returns a table of rows, where the return columns are defined in the stored procedure. I may have used the wrong nomenclature. I was trying to differentiate between a table in a database schema versus one defined in a function.
"The stored procedure returns a multi-row resultset via a SETOF[ROWTYPE] return value" might be a clearer description?