Subject Re: [IBO] Using InsertSQL, EditSQL, DeleteSQL
> 6. About 20 files with between 3 & 2000 records each so for the
> longest it takes about 5 min to transmit across the internet
> to the web server.

The first thing I would suggest is that you add temporary tables to the
web server database. You can then copy the new data into the temporary
tables, prior to the update. That can definitly use datapump and will
work quite quickly, but will not be bothered by transmission time.

Having copied the data to the temporary tables, it is in the same
database, and you can use stored procedures, local to the webserver, to
carry out the updates. Since the updates will run at server speed, the
delete and insert could be applied, although simple updates may be all
that is required.

Once the updates are complete, the temporary tables are emptied ready
for the next day's download.

Information being loaded into the temporary tables could be checked
against the main copy, and only loaded if it is different, so that the
temporary copy only holds updates/inserts.

Lester Caine
L.S.Caine Electronic Services