[Dbix-class] trying to figure out why DBIc query is slow

Peter Rabbitson 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:
> Aaron,
> 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[1]. If this is not the case please see if there is a 
difference between $rs->next and $rs->cursor.

[1] http://search.cpan.org/~turnstep/DBD-Pg-2.19.3/Pg.pm#pg_server_prepare

More information about the DBIx-Class mailing list