vb.org Archive - Cached Information

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

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Cached Information (https://vborg.vbsupport.ru/showthread.php?t=106746)

Logikos

01-30-2006 08:25 PM

Cached Information

I was wondering how exacly is the process proformed to cache data. Like here on vBulletin.org. The forum poral seems to be cached information retrived from the database every 10mins?

I was wondering how I can do something simalar to this. Like if I wanted to get the latest 10 threads posted on my forum I could run a SQL query and it gives me the infomation everytime the page is refreshed.

example:

PHP Code:


		
			
$gettitles = $db->query_read("

        SELECT title

        FROM " . TABLE_PREFIX . "thread

        WHERE forumid = 1

        ORDER BY dateline

        LIMIT 5

");





while ($thread = $db->fetch_array($gettitles))

{

        echo $thread['title'];

}

That will get the latest 5 thread titles in forum id 5. How can I cache something like that? Thanks guys! :)

Princeton

01-30-2006 09:05 PM

save it into datastore and and check timestamp
if (timestamp < TIMENOW)
{
DO QUERY;
}
else
{
use datastore info
}

another option is saving data into files (file name = md5(title+timestamp))

Logikos

01-31-2006 12:14 AM

Thanks princeton, I see how its done now :)

Princeton

01-31-2006 12:34 AM

no problem ... I have a similar system.
make sure you place some checks when editing/deleting a thread/post ... eg. update datastore information

Logikos

01-31-2006 12:38 AM

Yea, I need to get on the ball with learning the datastore system vBulletin has been using. I get lazy :p

All times are GMT. The time now is 07:05 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01789 seconds Memory Usage 1,715KB 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)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)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: