[Dbix-class] trying to figure out why DBIc query is slow
frank at korcett.com
Thu Nov 8 23:05:07 GMT 2012
It was pg_server_prepare.. thanks!
On Thu, Nov 8, 2012 at 12:40 PM, Peter Rabbitson <rabbit+dbic at rabbit.us>wro=
> 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
> > 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.
>  http://search.cpan.org/~turnstep/DBD-Pg-2.19.3/Pg.pm#pg_server_prepare
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive:
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the DBIx-Class