View Single Post
  #1  
Old 08-26-2009, 05:47 PM
imported_silkroad imported_silkroad is offline
 
Join Date: Dec 2003
Posts: 563
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Update datastore.smiliecache

Hi.

We changed the URL in the smilie.smiliepath to use our Content Delivery Network (CDN). However, when we look in the access logs, it is not using the CDN. So, I checked the dB and found the old URLs in:

datastore.smiliecache

Code:
a:12:{i:11;a:7:{s:8:"smilieid";s:2:"11";s:5:"title";s:8:"Confused";s:10:"smilietext";s:10:":confused:";s:10:"smiliepath";s:47:"http://www.oursite.com/images/smilies/confused.gif";s:15:"imagecategoryid";s:1:"3";s:12:"displayorder";s:1:"1";s:9:"smilielen";s:2:"10";}i:8;a:7:{s:8:"smilieid";s:1:"8";s:5:"title";s:21:"Roll Eyes (Sarcastic)";s:10:"smilietext";s:10:":rolleyes:";s:10:"smiliepath";s:47:"http://www.oursite.com/images/smilies/rolleyes.gif";s:15:"imagecategoryid";s:1:"3";s:12:"displayorder";s:1:"1";s:9:"smilielen";s:2:"10";}i:7;a:7:{s:8:"smilieid";s:1:"7";s:5:"title";s:4:"Cool";s:10:"smilietext";s:6:":cool:";s:10:"smiliepath";s:43:"http://www.oursite.com/images/smilies/cool.gif"; .... blah blah blah
Is there a way to update this smilie cache in the datastore without manually editing the dB?

Thanks!

--------------- Added [DATE]1251385811[/DATE] at [TIME]1251385811[/TIME] ---------------

We are finding vB very "CDN" unfriendly. So much of the image and static .js files are hard coded into the PHP files and the templates.

So of the images are nearly impossible to "clean up" so we can "off them" to a CDN.

Currently our CDN serves approx 20 GB of vB images, css and js per day, or about 4M objects per day.... which is over 45 objects per second.

Frankly, vB needs to be more CDN friendly !
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01223 seconds
  • Memory Usage 1,772KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete