Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^4: learning memcached

by punkish (Priest)
on May 21, 2011 at 03:10 UTC ( #906026=note: print w/ replies, xml ) Need Help??


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

> 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


Comment on Re^4: learning memcached
Replies are listed 'Best First'.
Re^5: learning memcached
by Anonymous Monk on May 21, 2011 at 03:18 UTC
    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://906026]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (11)
As of 2015-07-30 23:30 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 (273 votes), past polls