Logikos
01-31-2006, 01:59 AM
What I want to do is cache alot of information into vBulletins Datastore. Currently a new page I use just gets the information using 7 queries on every refresh.
I've never really used the vBulletin's Datastore system, but I understand how it works.
What I want to do is grab information for what would original invlove '7' queries to retrive the information.
SQL Listing example in simple terms.
$var1 = Query ForumID1 Order by Dateline Limit 8
$var2 = Query ForumID2 Order by Dateline Limit 8
$var3 = Query ForumID3 Order by Dateline Limit 8
$var4 = Query ForumID4 Order by Dateline Limit 8
$var5 = Query ForumID5 Order by Dateline Limit 1
$var6 = Query table1 Order by views Limit 10
$var6 = Query table1 Order by views Limit 10
Thats what would happen on EVERY refresh. I would like to cache all the info. Thats the tricky part. Is it possiable to run the 7 querys once every X mins and store ALL the information into a new datastore? If so, how would I store the info and grab it back out of the database?
I've never really used the vBulletin's Datastore system, but I understand how it works.
What I want to do is grab information for what would original invlove '7' queries to retrive the information.
SQL Listing example in simple terms.
$var1 = Query ForumID1 Order by Dateline Limit 8
$var2 = Query ForumID2 Order by Dateline Limit 8
$var3 = Query ForumID3 Order by Dateline Limit 8
$var4 = Query ForumID4 Order by Dateline Limit 8
$var5 = Query ForumID5 Order by Dateline Limit 1
$var6 = Query table1 Order by views Limit 10
$var6 = Query table1 Order by views Limit 10
Thats what would happen on EVERY refresh. I would like to cache all the info. Thats the tricky part. Is it possiable to run the 7 querys once every X mins and store ALL the information into a new datastore? If so, how would I store the info and grab it back out of the database?