[Catalyst] Where has Maypole's pager gone?

[Christian Hansen]

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
nGmedia
+46 40 660 17 50