TORASQL uncommitted data
Posted: Wed 17 Jan 2007 06:46
Hi,
Is there a limit to the amount of uncommitted data for a given session. I'm using the TOraSQL to insert 1000's of rows. The problem that I'm encountering at the moment is that it hangs on a call to TOraSQL.Execute. Calls earlier within the procedure to TOraSQL.Execute work fine but after about 20000 entries (4 * integer fields) the next call with 2000 entries (25 mixed fields) just hangs. It works fine if I commit after every .execute but I want to commit all data within one transaction.
Any ideas would be appreciated. Using Delphi 2006 and Delphi 2006 compatible components.
Cheers,
Rob.
Is there a limit to the amount of uncommitted data for a given session. I'm using the TOraSQL to insert 1000's of rows. The problem that I'm encountering at the moment is that it hangs on a call to TOraSQL.Execute. Calls earlier within the procedure to TOraSQL.Execute work fine but after about 20000 entries (4 * integer fields) the next call with 2000 entries (25 mixed fields) just hangs. It works fine if I commit after every .execute but I want to commit all data within one transaction.
Any ideas would be appreciated. Using Delphi 2006 and Delphi 2006 compatible components.
Cheers,
Rob.