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

Re: Query Problems

To: linux-india-programmers@xxxxxxxxxxxxxxxxxxxxx
Subject: Re: Query Problems
From: Arun Sharma <arun@xxxxxxxxxxxxxxx>
Date: Thu, 5 Apr 2001 14:14:43 -0700
In-reply-to: <001501c0be25$556eb540$0d01a8c0@krishna>; from krishna@xxxxxxxxxxxxxxxxxxxx on Thu, Apr 05, 2001 at 04:08:31PM -0700
References: <Pine.LNX.4.04.10103291052020.25296-100000@xxxxxxxxxxxxxxxxxxxxxxxxx> <005a01c0b886$47209520$0d01a8c0@krishna> <20010329115658.A8399@xxxxxxxxxxxxxxxxxxxxx> <00aa01c0b88d$27865b30$0d01a8c0@krishna> <001501c0be25$556eb540$0d01a8c0@krishna>
User-agent: Mutt/1.2.5i

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.

	-Arun

References:
- Query Problems
  - From: Krishna Srinivasan

Prev by Subject: Query Problems
Next by Subject: query regarding utility.
Previous by thread: Query Problems
Next by thread: query regarding utility.
Index(es):
- Subject
- Thread