php - JSON Flat file vs DB querying -


i'm working on site has store locator built in.

since have similar sites developed in past, have experienced troubles when had search peaks hitting database (mysql) hard. these past location search engines querying database results.

now have taken different approach, since i'm not 100% sure, thought asking great community make me feel more secure direction or stick did before.

so new search, instead of hitting database requests, i'm serving search json file regenerates (querying database) when updated, created or deleted on locations list.

  • my doubt is, can high load of requests on json file have same effect high load of query requests on database?

  • serving search results json lower impact on db (and server resources) approach or it's not idea?

maybe out there had take same decision , can share experience me, or maybe know how things , recommend me approach.

flat files poor man's db , can more problematic heavily pounded database. example reading , writing file still requires lock, , not scale, same file may not accessible app servers.

my suggestion 1 of following:

  1. benchmark current hardware, identify bottlenecks, scale out or accordingly.

  2. implement caching layer, save on costly queries readonly data.

  3. consider more high performant storage solutions such aerospike or redis

  4. implement real full text search engine such elasticsearch or solr.

response comment #1:

you accomplish same thing without having read/write flat file (which must accessible app servers), caching data. here's quick n dirty rundown of how it:

zip + 10 miles:

query database, pull store data, json_encode, cache using key construct 92562_10, store in cache. when other users enter 92562 + 10 pull data cache vs database (or flat file).

city, state + 50 miles:

same above, except key construct may murrieta_ca_50.

but caching layer better performance, , cache server available app servers, easier having install/configure nfs share file on network.


Comments

Post a Comment

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

i have following sample code used pre-decrement void function(int c) { if(c == 0) { return; } else { cout << "dp" << c << endl; function(--c); cout << c << endl; return; } } this function give output input 4 : dp3 dp2 dp1 dp0 0 1 2 3 but when use post decrement void function(int c) { if(c == 0) { return; } else { cout << "dp" << c << endl; function(c--); cout << c << endl; return; } } output goes in infinite loop dp4 can explain me in detail why happens ? this happens because function(c--) called same value of c , when finishes c decremented. recursively called, hence called same value no chance of return , hit stack overflow error. assume this, int x = 1, y = 0; y = x++ result y == 1 , x == 2. if y = ++x , bot x , y 2.
Read more

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

i added new project. made mistake in projectname.conf file in sites-available apache2, led me reinstalling apache2. after reinstalling , re-enabling projects on every page of every project .. <body> run(); </body> .. i've run composer update, restarted service, restarted pc, checked config files, tried disabling new project. there nothing in error log, , access.log: 127.0.0.1 - - [15/may/2015:01:40:47 +0200] "get / http/1.1" 304 181 "-" "mozilla/5.0 (x11; ubuntu; linux x86_64; rv:38.0) gecko/20100101 firefox/38.0" maybe i'm forgetting apache2 reinstall? don't think did different last time installed it. looks haven't setup php correctly. take @ this great guide , maybe you're forgetting link php config apache2.
Read more

php - How can I echo out this array? -

i don't know how go grabbing data in variable , put foreach loop. class tree{ private $info = array( array('name'=>'jim','state'=>'nu','company'=>'nu','phone'=>array('cell'=>'5615111111','office'=>'5611111111'),'email'=>array('primary'=>'exs@example.com','ex@there.com')), array('name'=>'joe smith','city'=>'phoenix','phone'=>'4805551111','email'=>'jsmith@some_email.com'), array('name'=>'john doe','city'=>'chandler','company'=>'doe co.','email'=>array('jdoe@gmail.com','personal'=>'email@email.com'),'phone'=>'6025550002') ); } if you're inside of class, can access private variable using $this->variablename . example, i
Read more