If I give Transaction Size as 1, then Array Size also comes down to 1, right ?chulett wrote:... About all you could control from a Transaction Size standpoint would be if each set of records from any given 'key set' were committed per key change. That would take a value of 1.
i,e once set of keys goes to Database, delets, commits and processes anither key set, correct ?
Also, If I am right, then Transaction Size cannot be a less than Array Size, right ???
yes, this is running on daily basis.. 2 times per day...That time for those volumes might be great in a weekly or monthly process, less so for a daily one.
actually, I was wondering about Array Szie and Transaction size, because, earlier when I was usign Array Size = 1000 and Transaction Size = 1000, the DBA said that there are no COMMITS being issued, but over this weekend I have implemented the chages, so will check with the DBA on Monday regarding How frequent are the comits being issued now 8 ie. After Array Size= 100 and Transaction Size = 200 ).
Now, what more I need to explore is about Bulk Deletes... i.e framing a single WHERE claue and issuing the Delete command... For this I need to check with the DBA what is the maximum length of a WHERE clause....