[Catalyst] Where has Maypole's pager gone?

Christian Hansen ch at ngmedia.com
Thu Apr 28 20:15:42 CEST 2005

On 2005-04-28, at 19.55, Perrin Harkins wrote:

> [ accidentally sent off-list... ]
> Christian Hansen wrote:
>> Similar on the surface, but not behind the scenes. Sweet uses 
>> placeholders while the above patch will create a new prepared 
>> statement on each query. This makes a big difference in performance 
>> and stress on RDBM.
> Only certain combinations of MySQL and DBD::mysql support placeholders 
> for LIMIT clauses.  If you Google for it, you'll see tons of 
> discussion about the problem.  Not sure where it's at now.

I have not experienced any problems as long as rows and offset are 
bound as integers, which Sweet does.


Christian Hansen
+46 40 660 17 50

More information about the Catalyst mailing list