an index on any appropriate data (date, sum) should also help tremendously.
Thomas
"Danny Melton" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi all,
>
> I am curious to know if the query times I'm seeing are reasonable or not.
> Here's my situation:
> I am using a database to
At 09:43 AM 12/18/2003, you wrote:
Hi all,
I am curious to know if the query times I'm seeing are reasonable or not.
Here's my situation:
I am using a database to keep up with web statistics. The table is
currently growing at about 2 million records a day. The sample table I am
working with has
Hi all,
I am curious to know if the query times I'm seeing are reasonable or not.
Here's my situation:
I am using a database to keep up with web statistics. The table is
currently growing at about 2 million records a day. The sample table I am
working with has right at 4 million rows.
When I exe