Page 1 of 1

Caching of SQL tables

Posted: Wed Mar 01, 2017 2:23 pm
Has anyone considered using the mysqlnd-qc PHP extension to cache some of the database calls?

Potentially, this would be useful on some of the larger database calls (eg to items and offers), provided that we remember to clear the cache when a listing is activated / edited / ends etc.

Some more details appear at: ... hp-mysqlnd

I might investigate this when I have chance.....

Re: Caching of SQL tables

Posted: Wed Mar 01, 2017 7:43 pm
Having looked at this further, it probably makes more sense to look at developing an improved cache based on the phpbb cache code (then any changes to that could be brought over to Enuuk). ... hpbb/cache

Re: Caching of SQL tables

Posted: Fri Mar 10, 2017 8:37 am
I have started to implement my own SQL cache and results are already very promising :D

I am currently concentrating on the getListFromDB() calls in the classes where the data is not frequently updated, and then clearing the cache for the SQL calls linked ot a specific class each time that saveToDB() is called.

This has resulted in even faster response times on page loading and less use of memory as the SQL process is released to do some more of the intensive SQL commands.