vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Big Board Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=172)
-   -   Optimizing CMS (https://vborg.vbsupport.ru/showthread.php?t=129156)

rootnik 10-15-2006 04:48 PM

Optimizing CMS
 
Please look at my dev site:

http://dev.friendcodes.com/

You can see that I have 3 queries in that left column that will be called on all non-forum pages.

"Latest Headlines"
"DSigner Images"
"Recent Posts"

Would be be easier on the server to run a cron job every 5 minutes that would write a "static" file that would then be included in the php, instead of calling the database 3 times per page load?

Razasharp 10-16-2006 03:00 AM

If it's accessed more than once every 5 minutes... then I'd say yes.

rootnik 10-22-2006 12:46 AM

Quote:

Originally Posted by Razasharp
If it's accessed more than once every 5 minutes... then I'd say yes.

I have set up a caching system for my home made CMS, and will post results once my dev site goes live.

The caching script makes several queries to the database and writes them to an .html file every 5 minutes. I then use PHP's output buffering in my php scripts, instead of using the template system.

I'm being selective on what queries I cache, because I am sure that the small ones are probably faster to run in real time than using the output buffering.


All times are GMT. The time now is 04:46 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01004 seconds
  • Memory Usage 1,712KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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