PDA

View Full Version : Update datastore.smiliecache


imported_silkroad
08-26-2009, 05:47 PM
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

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 1251385811 at 1251385811 ---------------

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 ! :(