I have data files in client side which need to be striped out the infos from each record and loaded them into database table. After that, we need to process the data based on this table. The problem is: because the server and client are in deferent place, so the whole process is very slow. I have tried used the PL/SQL table first used to stored the data temporarily, and then put them into the table by direct load , but it seems not pretty much help.
Does any one have experimenced the same or have any method to speed the whole peocess. I'm using ORACLE form as the front-end.