Prepared statements with bind variables along with cake 2.x paginator?


#1

Hi!

I have a large application in CakePHP 2.5.2 and Oracle Database 11g.

The amount of user has grown a lot and now I’m having performance problems with the database.

I would like to know if there is any way to use prepared statements and bind variable in queries generated by the PaginatorComponent?

I think that would give me a good performance gain.