Re: Speed up

From: <michael_bialik_at_my-deja.com>
Date: Sun, 26 Mar 2000 20:54:51 GMT
Message-ID: <8bltek$vsu$1@nnrp1.deja.com>

Hi.

If you are using 8i - look for implementation of matherialized views otherwise - create cumulative tables ( month and year levels ) and update them by triggers.

HTH. Michael.

In article <8bcimu$602$1_at_nn-os105.ocn.ad.jp>, "sang" <laoxiu100_at_hotmail.com> wrote:
> Hi, all
>
> In our system, database server collects data from nodes of all
country.
> In my application, i will gernerate day,week,month and year reports to
> manager through LAN.
> The question is day report is ok, but month and year report is too
slowly
> for data communication through LAN is too large.
> I think i can process data in the side of database server , and
tranmit only
> the result of reports to client computer.
>
> What is the best method for me to do it?
>
> Thanks in advance.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Mar 26 2000 - 14:54:51 CST