[Dbix-class] trying to figure out why DBIc query is slow
rabbit+dbic at rabbit.us
Thu Nov 8 18:40:47 GMT 2012
On Thu, Nov 08, 2012 at 10:55:03AM -0600, Frank Sheiness wrote:
> Thanks for your reply. There are differences between the queries, but I
> have confirmed multiple times that using psql or a DBI script, both queries
> return in under a second (with the same date ranges).
But is that with the same queries wrt bind-values? Perhaps you are
getting bitten by. If this is not the case please see if there is a
difference between $rs->next and $rs->cursor.
More information about the DBIx-Class