mace
May 23rd, 2000, 03:07 AM
Hi.
I'm writing an application that will import a recordset (depending on the selection criteria) from one db table to another db table. However, my application seems to stop responding when I'm selecting from a large database. Is there a way to get this to work? I check the table after I kill the process and it does insert the some of the recordset. The problem is, it is nowhere near completion.
Note: The databases are located in different servers.
Any and all help is appreciated. Thanks.
I'm writing an application that will import a recordset (depending on the selection criteria) from one db table to another db table. However, my application seems to stop responding when I'm selecting from a large database. Is there a way to get this to work? I check the table after I kill the process and it does insert the some of the recordset. The problem is, it is nowhere near completion.
Note: The databases are located in different servers.
Any and all help is appreciated. Thanks.