Re: Large table design

From: <goldenge_at_my-deja.com>
Date: Wed, 16 Aug 2000 08:37:19 GMT
Message-ID: <8ndjru$3ti$1@nnrp1.deja.com>

Dear sir,
Thanks for your help.
But I think this is not a good solution. Because the snapshots often just for the remote database, may be not availible for one local database. Not sure this can increase the performance of query.

In article <3999e72b.9990445_at_news.earthlink.net>, andreyNSPAM_at_bookexchange.net wrote:
> Create snapshots/materizlied views on top of it and refresh them
> nightly, those static reports will be available during the day for
> fast and easy querying.
>
> On Tue, 15 Aug 2000 09:18:21 GMT, goldenge_at_my-deja.com wrote:
>
> >Hi all,
> > Our application will use very large table, the table will be
> >inserted into more than 400000 records one day. we need to count the
> >daily & monthly statistic from this table, how to design this
request,
> >if anyone have the expirence, please give us some advise,
> >We need your help.
> >
> >Many Thanks.
> >Gewuyue.
> >
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Aug 16 2000 - 03:37:19 CDT