Peter Speltz wrote:
Maypole can take several minutes to fetch all the rows from a big table
 then throw them all away except the first ten. That's why it's
important to use a proper pager :)

Interesting. So it does not hang forever.

With the lack of patience I have it's effectively forever, because I kill the process :)

What's  the propoer pager?
Does maypole use it by default in list ? If not, can you share your
pager code?

No, Maypole uses Class::DBI::Pager by default, which fetches everything and then throws it away. Dave Baird wrote Class::DBI::Plugin::Pager, which does the right thing. I use a slightly modified version of that because of the different count plugin I use. Can't remember whether DB has put my mod into his package as well.

Cheers, Dave


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Maypole-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/maypole-devel

Reply via email to