vb.org Archive - Little help: Rebuild Post Cache

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)

- - Little help: Rebuild Post Cache (https://vborg.vbsupport.ru/showthread.php?t=183666)

raywjohnson

06-27-2008 05:00 AM

Little help: Rebuild Post Cache

Greetings!

The board that I admin has nearly 5 million posts.

I suspect that I need to AdminCP->Maintenance->Update Counters->Rebuild Post Cache.

Should I disable the board before doing this?

Is this a processor intensive operation? (will it put a heavy load on the server?).

Thanks for any info or insight.

--RayJ

Marco van Herwaarden

06-27-2008 06:21 AM

Yes this is processor intensive.

But why do you need to do this?

raywjohnson

06-27-2008 08:33 PM

Quote:

Originally Posted by Marco van Herwaarden (Post 1560184)

Yes this is processor intensive.

But why do you need to do this?

Actually, I am not sure that it is needed.

I problem is with a modification that displays an icon based on there being info contained in a field:

PHP Code:


		
			
<if condition="($post['fieldname'] == '')">

ICON_A

<else />

ICON_B

</if>

I was not working (due to a bug!). After I fixed the bug, the ICON does not change in older posts. (the newest ones work as expected). So I suspected that the older posts were being drawn from the cache.

--RayJ

ssslippy

06-27-2008 08:38 PM

If you give it time it should automatically update the cache. If it doesnt then run that.

raywjohnson

06-27-2008 08:59 PM

Thanks! I thought that might be the case.

I will just wait for it to update itself. (I would rather not force it!)

--RayJ

Marco van Herwaarden

06-28-2008 10:18 AM

Just clear out the postparsed table:

[sql]TRUNCATE postparsed;[/sql]

Cache will be rebuild while posts are viewed for the first time.

raywjohnson

07-01-2008 02:24 AM

Thank you!

--RayJ

All times are GMT. The time now is 09:15 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01047 seconds Memory Usage 1,721KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: