Caching of SQL tables

General Discussion about the commercial Enuuk Auction Platform
Post Reply
RWAP
Site Admin
Posts: 745
Joined: Fri Jan 08, 2010 2:23 am
Location: Stoke-on-Trent
Contact:

Caching of SQL tables

Post by RWAP » 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: https://blog.engineyard.com/2015/query- ... hp-mysqlnd

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

RWAP
Site Admin
Posts: 745
Joined: Fri Jan 08, 2010 2:23 am
Location: Stoke-on-Trent
Contact:

Re: Caching of SQL tables

Post by RWAP » 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).

https://github.com/phpbb/phpbb/tree/mas ... hpbb/cache

RWAP
Site Admin
Posts: 745
Joined: Fri Jan 08, 2010 2:23 am
Location: Stoke-on-Trent
Contact:

Re: Caching of SQL tables

Post by RWAP » 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.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest