PHP Classes

Easydb Cache package blog

Recommend this page to a friend!

Latest Easydb Cache package blog posts

  All package blogs All package blogs   Easydb Cache Easydb Cache   Blog Easydb Cache package blog   Post article Post article  

1. How to Make PHP Prepared Statements Cache Be Used to Run Faster the Same Query Using Different Parameter Values

Updated on: 2021-02-22

Posted on:

Prepared statements are used to execute SQL queries from template strings. Those templates have marks which will be replaced by query parameter values before the query is executed.

Using prepared statements adds some overhead to the time it takes to execute a query because the query template string needs to be parsed first before the parameter values are replaced.

This class implements prepared query caching, so it avoids the overhead of parsing the same prepared statement query every time it needs to execute the same query, even if it uses different parameter values.


Blog More ...   Post a comment Post a comment   See comments See comments (0)   Trackbacks (0)


  All package blogs All package blogs   Easydb Cache Easydb Cache   Blog Easydb Cache package blog   Post article Post article