Caching every 1 second

[eluser]sn4k3[/eluser]
hi,

Situation:

I want reduce MySQL querys
Webpage makes a request every 1s to retrieve updated auctions from MySQL

So if theres 100 users viewing that page it will make 100 mysql querys per second
Im thinking in a cache solution so instead make 100 MySQL querys, do only one

----

If i use cache it will respond at time every 1 second? since cache reads and writes to disk
Also can anyone point me for a good cache library

Thanks