1
LazyBadger
Block cache - please explain again

I had most of blocks on main page cached (with different TTL, if it's important). Without cache (totally disabled)page generates ~460-480 queries, 70-90 for live cache and some not-cached blocks.
BUT - sometimes I see:
- Where are visitors on site (even on frontpage)
- Queries counters jump to smth. like "571 Queries"

How, goddam, it can be???
Quis custodiet ipsos custodes?

Webmaster of
XOOPS2.RU
XOOPS Modules Proving Ground
XOOPS Themes Exhibition

2
LazyBadger
Re: Block cache - please explain again

Bump...
Quis custodiet ipsos custodes?

Webmaster of
XOOPS2.RU
XOOPS Modules Proving Ground
XOOPS Themes Exhibition

3
frankblack
Re: Block cache - please explain again
  • 2005/8/24 16:23

  • frankblack

  • Just can't stay away

  • Posts: 830

  • Since: 2005/6/13


460-480 queries? So many modules and blocks running on your startpage?

Is the option for updating templates and themes automatically disabled?

I made a small test locally and for one user with only a few blocks and it saved me 8 queries. Just a guess!

4
LazyBadger
Re: Block cache - please explain again

Quote:

460-480 queries? So many modules and blocks running on your startpage?

Because it's "Proving Ground" I have some extra blocks, which (I think) will never appear on live site at the same time, but... It's only small subset of blocks, as you can see here

Quote:

Is the option for updating templates and themes automatically disabled?

No, I can ignore permanent decreasing on 30 queries, caching do jobs better
Quote:

I made a small test locally and for one user with only a few blocks and it saved me 8 queries. Just a guess!

See comments on XOOPS Tips Article

And one more observation - after update to 2.0.13.1 from 2.0.9.3 (same block cache settings for all frontpage block - re-checked a lot of times) I'm totally lost - minimal amount of queries now 130 instead of 72, but... no more 500+ queries incidents detected and overall slowdown to 20-40-60 seconds on page show also go away, average responce time is 1 second less than before update
Quis custodiet ipsos custodes?

Webmaster of
XOOPS2.RU
XOOPS Modules Proving Ground
XOOPS Themes Exhibition

5
LazyBadger
Re: Block cache - please explain again

Bump! Please, explain me my problems! Or I must wrote about block cache same thing as about MySQL 4.1 support for 8-bit text?!
Quis custodiet ipsos custodes?

Webmaster of
XOOPS2.RU
XOOPS Modules Proving Ground
XOOPS Themes Exhibition

6
Dave_L
Re: Block cache - please explain again
  • 2005/9/10 13:58

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


It's hard to help without knowing what the queries are, and which blocks or modules are causing them.

Some modules improperly do queries before the code that handles the caching, which defeats the benefit of caching.

Some modules are inefficiently coded and have queries in loops.

Login

Who's Online

154 user(s) are online (73 user(s) are browsing Support Forums)


Members: 0


Guests: 154


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits