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

[Frank Sheiness]

It was pg_server_prepare.. thanks!

On Thu, Nov 8, 2012 at 12:40 PM, Peter Rabbitson <rabbit+dbic at rabbit.us>wro=
te:

> 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
>
> _______________________________________________
> 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:
> http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20121108/959=
0eff2/attachment.htm