c# - Is caching as important with MongoDB as with MySQL? -


i writing c# http request server web game , using mongodb database. more efficient still cache whatever can in c# application? or faster request mongodb every thing. expecting around dozen selection queries per minute each active player, , maybe 1 or 2 save/update queries per minute.

"dozen selection queries per minute each active player" doesn't tell anything. have bearing we'd need know number of active players, amount of time each query taking, table structure, queries in use (including amount of data returned), statistics on server load, , others such whether using mongo's ability shard database, etc.

regardless, before setting type of caching i'd highly suggest start profiling system. need know bottlenecks are, if exist. isn't guess at, need hard , real statistics.

with information in hand can make determination whether need

  • to make minor fixes code
  • implement type of caching strategy
  • shard database server across multiple servers
  • rearchitect large swathes of code
  • scale (buy bigger servers)
  • or fix internal network issues.

point is, don't start caching stuff in hopes of getting performance increase later. caching increase performance kill depending on huge number of factors.

one other thing add here. if using web farm host request server complexity , hardware costs involved in caching data locally each independent web server grows drastically.

hardware costs go due increased memory requirements on web server(s) when trying keep data cached in memory on machines.

complexity increases when trying keep cached copies in sync don't become stale. imagine game require information 100% current. sites facebook , others can afford little out of sync. when game server goes out of sync have negative impacts on player usability.

assuming deploying single web server , single db server, adding caching capabilities now might cause huge amount of pain in event move multiple web servers and/or multiple db servers.

finally, if reason deploying single machine hosts both database , web server caching ludicrous.


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