Hi Bjorn -
That's a lot of records...
Without knowing the details of your problem, I'll guess
the best way is to eliminate the 3 lookup you probably
do in the Oracle database. What about programming a
trigger function i Oracle for your main insert/update, so
the SQL-trigger function do the lookups and perhaps other
controls and then do the insert/update.
Bo Thomsen
GeoConsult I/S
Denmark
> -----Oprindelig meddelelse-----
> Fra: Bjorn Veltman [SMTP:[EMAIL PROTECTED]]
> Sendt: 7. oktober 1999 09:21
> Til: [EMAIL PROTECTED]
> Emne: MI Speeding up things
>
> Hi,
>
> I have a MapMasic program which uses a table of 900000 records to update
> an
> Oracle table (many million records). The problem is it has to do 3 checks
> on the Oracle table for every record. My estimation is now that it is
> going
> to take me 10! days before it is finished.
>
> Would anybody have a suggestion how to speed things up a little bit?
>
> Thanks in advance
>
> Bjorn
>
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
