[Subject Prev][Subject Next][Thread Prev][Thread Next][Subject Index][Thread Index]

Re: Query Problems

On Thu, Apr 05, 2001 at 04:08:31PM -0700, Krishna Srinivasan wrote:
> Hi All,
> I have this table which stores all the requests made for a product along
> with the requester's ID.
> At the end of the day I would like to determine the most requested products.
> How can I query this
> database and retrievethe most request products in descending order without
> using any temporary
> table.

Accessing the database for every product request makes it slow. I'd
store this data in memory and periodically flush it to the db in a
separate table.