php - How best to implement Memcached on a Ecommerce Website -


i've got large ecommerce website running lamp , wondering how best implement memcached?

  • store queries in memcached period - sounds pointless

  • store important data product information memcached , make sure proper updates can expire correctly - sounds end end solution.

  • store complex query results not change - involves lot of static code

trying overview of changes should make take best advantage of memcached.

thanks :)

i'd let users decide.

in other words rather trying second guess work best, i'd rework database queries use memcached along lines of;

  1. can memcache answer query? if - return results cache.
  2. if not 1), pull results database , write memcached next time it's in cache.
  3. ensure updates / inserts / deletes invalidate appropriate cache keys.

now given 3) might complex, i'd use factor choose queries load through cache - if it's hard and/or time consuming invalidate cache, don't cache queries start with.

because memcached automatically dump least used keys when store approaches capacity, can set never expire , allow available resources determine in cache. largely determined user behaviour (which products popular etc) , hence first comment letting users decide.

it's worth saying should ensure mysql database tuned first can easier win. query caching, checking heavy queries explain tune indexes etc, of can have greater impact.


Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more