Re: Inserting Large Amounts of Data

[Eric Gentz <ej.gentz@HOSP.WISC.EDU>]

Two ideas:

Loading the PERSONAL_DATA table into an array and then searching for the
emplid using the array will make the SQR much faster. I have done the same
thing loading Financial data. When you load the array, sort by SSN and use
a binary search. If you need the code, feel free to email me directly.

Second, I would also use an array for looking at the job table. You can
create an array with emplid, empl_rcd#, effdt, and effseq (all the keys
from the job table). When you write the JOB table write the array as well.
When you need to determine if a row is in the job table, use the array.

Using arrays will make the loading go muich faster but it is taxing on the
box you are running upon.

HTH,

Eric
Eric Gentz                              Interested in a real operating system?
UW Hospital & Clinics             <http://www.apple.com>
610 N. Whitney Way               "You can surrender without a prayer, but never
Madison, WI 53705                    really pray, pray without surrender.
608-263-9345                      " You can fight without ever winning, but
never
ej.gentz@hosp.wisc.edu             ever win without a fight" -- Neal Peart
--------------------------------------
"You can twist perceptions, but reality won't budge."   -- Neal Peart