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

**URL:** <https://discourse.cakephp.org/t/prepared-statements-with-bind-variables-along-with-cake-2-x-paginator/2786>\
**Category:** Need Help\
**Created:** [June 27, 2017, 2:35pm UTC](https://discourse.cakephp.org/t/prepared-statements-with-bind-variables-along-with-cake-2-x-paginator/2786 "2017-06-27T14:35:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![onir](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/onir/32/685_2.png) [@onir](https://discourse.cakephp.org/u/onir)\
**Post date:** [June 27, 2017, 2:35pm UTC](https://discourse.cakephp.org/t/prepared-statements-with-bind-variables-along-with-cake-2-x-paginator/2786/1 "2017-06-27T14:35:27Z")

</div>

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.