Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re^3: learning memcached

by Anonymous Monk
on May 21, 2011 at 03:04 UTC ( #906025=note: print w/ replies, xml ) Need Help??


in reply to Re^2: learning memcached
in thread learning memcached

Or, am I reading the results wrong?

You're not reading the results wrong, I obviously missed the count :)

Another (insert better word here) "flaw" , is your sql query is too simple :) The way I understand memcached, you get benefit if you cache data which is expensive to calculate


Comment on Re^3: learning memcached
Re^4: learning memcached
by punkish (Priest) on May 21, 2011 at 03:10 UTC
    > Another (insert better word here) "flaw" , is your sql query is too simple :) 
    > The way I understand memcached, you get benefit if you cache data which is 
    > expensive to calculate
    
    I don't see why that should matter. Sure, on a more complicated and slow query, retrieving an already calculated result will be faster. However, retrieving even the simplest of results from memory should be faster than opening a file on disk, preparing a db handle, querying, and then returning the result. At worst, it should be about the same, not 30% worse!


    when small people start casting long shadows, it is time to go to bed
      However, retrieving even the simplest of results from memory should be faster than opening a file on disk, preparing a db handle, querying, and then returning the result.

      I don't think SQLite uses sockets. memcached does use socket. That might explain the difference, maybe benchmark against a database which uses sockets.

      Or maybe opening "foo.txt" is skewing the results (unlikely, but it could happen)

      At worst, it should be about the same, not 30% worse

      I literally don't know about that, you might wish to ask the mailing list (amusing story about that).

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://906025]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (6)
As of 2015-07-07 05:58 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (87 votes), past polls