[RC] SQL Cache (Cached Generation)

[R45]

Overhead on multiple queries is very low with modern RDBMs. The whole query count argument is overrated, as drathbun, it's a lot to do with the content of the query more than anything. Splitting a complex looping JOIN into two or three queries can yield quantum leaps in performance, depending on the makeup.

That said, unneccesary queries should always be avoided.

[Doobdee]

Hi,

Small update on this MOD.

It uses same approach as before, but known bugs are fixed. This caches SQL queries, adds SQL queries counter and page generation time to footer of site.

Download Here

I relesaed this version to phpBBStyles community some time ago, but I forgot about this thread. If you users have no problem, I will submit.

[Marnboorapa]

I hope you will see my request

My requests ::

1. Please make this mod can install without XS system [ many people use phpbb original cache not XS system ] .

2. Reduce useless sql query from original phpbb.

[devinliao]

Great ModD This is going to help my forum for sure.

[Ikaemos]

Great Mod, as eXtreme mod

Great job 8)

[net83it]

any news on this mod?

has it some collateral effect?

[EzerchE]

is this normal?

index.php

Debug: page generation = 1.51142 seconds, sql queries = 167

[drathbun]

is this normal?

...

sql queries = 167

No, it is not normal. You probably have some bad code / MODs installed.

[yakusha]

new versinon?

[EzerchE]

i have this mods:

Cash Mod 2.2.3
Color groups 1.2.1
Enhanced Admin User Lookup 1.1.1
Restrict Guest Access 1.0.0
send pm on register 2.0.14a_em
Rabbitoshi 1.0.0
Referral Plus 1.4.0
phpBB static URLs mod _rewrite 1.0.0
Restrict Images in Posts 0.3.0
delete_multiple_posts_1_0_0
Foxy in a box
phpBBGTalkMOD-1.0.2
percentage_post_fix 1.0
File Attachment Mod v2.4.0a
Enhanced Admin User Lookup 1.1.1
CrackerTracker 5.0.2
delete_all_user_posts_1.0.0.txt
signatures_control_1.2.3em
Protect Install 1.0.0
yellow_card_1.4.12em
Redirect User Fix 1.0.0
Rules Management 1.0.2
photo_album 2.1
adv_posts_merging_2.1.2
Restrict Topic Creation by Postcount

can i find which modes cause that problem? or can i see whats that sql queries?

[greatgamer]

So is this stable now?

[stevemagruder]

Thank you for this great mod! I just deployed it today and it's working beautifully.

However, I am wondering why this caching isn't applied to queries in viewtopic.php. Given that most threads will be read (esp. by spiders) rather than written to, wouldn't this be a good idea? Or am I missing something?

[enderandrew]

My MySQL query cache hit rate jumped from 76% to 85% with a couple of simple changes I made on my board a while back, and you could see the performance improvement.

Might I ask what changes you made?

[greatgamer]

So is this stable enough to install on a live board?

[stevemagruder]

So is this stable enough to install on a live board?

Yes. A caveat is when you have other mods installed that perform similar queries that are cached with this mod -- those should be cached similarly. And this also goes for clearing caches whenever similar data is inserted/updated in other mods.