How to Make PHP Prepared Statements Cache Be Used to Run Faster the Same Query Using Different Parameter Values - Easydb Cache package blog

Recommend this page to a friend!
  All package blogs All package blogs   Easydb Cache Easydb Cache   Blog Easydb Cache package blog   RSS 1.0 feed RSS 2.0 feed   Blog How to Make PHP Prepa...  
  Post a comment Post a comment   See comments See comments (0)   Trackbacks (0)  

Author:

Updated on: 2021-02-22

Posted on: 2021-02-22

Viewers: 165 (February 2021)

Package: Easydb Cache

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.




About the Easydb Cache Package

The package Easydb Cache is one of the few PHP packages that was considered notable recently because it does something that is worth paying attention.

The basic purpose is: Cache database query prepared statements

Here follows in more detail what it does:

This class can cache database query prepared statements.

It extends the EasyDB database access cache to alter the way the prepared statements are processed to make it run faster.

On the first time the prepare function is called, it stores the results of the prepare function in a class variable.

Next time the prepare statement is run, it returns the values previous stored in the cache class variable.

Conclusion

The Easydb Cache can be downloaded from download page or be installed using the PHP Composer tool following instructions in the Composer install instructions page.

This package was considered notable for implementing its benefits in a way that is worth noticing.

Notable PHP packages can be often considered innovative. If this package is also innovative, it can be nominated to the PHP Innovation Award and the author may win prizes and recognition for sharing innovative packages.

If you also developed your own notable or innovative packages consider sharing them, so you can also earn more visibility for your package as well nice prizes.

One nice prize that many PHP developers want and you may like is the PHP elePHPant mascot plush.




You need to be a registered user or login to post a comment

1,573,517 PHP developers registered to the PHP Classes site.
Be One of Us!

Login Immediately with your account on:

FacebookGmail
HotmailStackOverflow
GitHubYahoo


Comments:

No comments were submitted yet.




  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   RSS 1.0 feed RSS 2.0 feed   Blog How to Make PHP Prepa...  

For more information send a message to info at phpclasses dot org.