Re: NEED: more Effiency

From: Richard Woest <r.a.woest_at_kpn-telecom.nl>
Date: 18 Aug 1998 06:25:24 GMT
Message-ID: <01bdca70$fbf1aef0$f12b15ac@tonta000072>

Hi,
You can try to create a view based on the columns from the various tables. In that case you would only have to query one table..

Richard

Seth E. Broomer <broomers_at_ucsub.Colorado.EDU> schreef in artikel <Pine.GSO.3.96.980817114613.26832A-100000_at_ucsub.Colorado.EDU>...
> Hi,
> I am querying about 10 tables that through one way or another are
> related to each other, My total amount of records that I'm extracting
> from all of these tables are aroud 500,000. Right now I pull as many
> records as i can from one table to set up all the other relations. I
then
> use cursors to fetch the other records in the other tables into my new
> table and update those records,
>
> It takes days to do 500,000 records. How can I make this process go
> faster?
>
> thanks
>
> seth
>
>
Received on Tue Aug 18 1998 - 01:25:24 CDT