Hi,

We have a client who processes a lot of transactions monthly. Last month the bank reconciliation file from one account contained over 15,000 records and this is a normal month. Their busy months run from December to March/April.

We have written a fairly powerful auto-reconciliation interface driven by rules which auto-create G/L transaction and then mark then as reconciled. Now we are importing, generating transaction and reconciling them but some of the transactions are being matched by string comparisons so the import is a bit tedious and slow (2 to 3 minutes).

When running this utility we are seeing clients on the network go dead and even the user running the import is getting the "Restart or Quit" message as the server is not responding. Of course, waiting a random amount of time the system returns to normal and processing can proceed.

We began thinking that what is needed is really to see import and export (again more so "import") moved to it's own stream within the application or something to this effect. This brought me to thinking what are other partners doing in these import heavy environments?


Is there anything existing in SERP and HAL that we can do to stop the import from hanging the system as we have a second client who moves items out (export aprox...2,000 items) for the purpose of building a catalog and they experience this issue as well. It is a small database but we are formatting the out file for them to use in their catalog builder but in any light this is not a real heavy workload.

Thanks in advance for all advise.