From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
---|---|
To: | Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>, pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Memcached for Database server |
Date: | 2011-05-20 06:26:44 |
Message-ID: | 4DD609A4.1000902@postnewspapers.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 20/05/11 13:00, Adarsh Sharma wrote:
> Thanks Craig,
>
> I spend some time on Memcahced and your explaination also helps.
> I think it is used only for applications where load is very high & users
> issue read only queries to the database.
Er, yes. You can't really cache queries that write to the database, and
it doesn't make sense to cache queries where the answers change for
every query. A cache is only useful where the same query returns the
same result (for a while, at least) and is executed very, very often.
> Can you give the Real Example where memcached is used heavily.
Google can. You'll need to build your independent research skills if
you're going to succeed at what you're doing; it will not work well for
you to rely on others making all the effort to explain everything to
you. You will usually get better results when you ask people for help if
you can show them that you have already made an effort to discover the
answer for yourself.
> fore.g How Facebook, You tube use it .
Five seconds on Google found:
http://www.facebook.com/note.php?note_id=39391378919
--
Craig Ringer
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2011-05-20 08:01:59 | Re: Memcached for Database server |
Previous Message | Merlin Moncure | 2011-05-20 00:07:39 | Re: Unique Session ID in PGSQL? |