|
View previous topic :: View next topic
|
| Author |
Message |
sandhyaimmadi
New User
Joined: 18 Aug 2008
Posts: 50
Location: Bangalore
|
|
|
|
Hello,
what is the command to issue a COMMIT after every 1000 records.
Please let me know |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
the same You would use after 100 or 10000 
it' s a program task to keep a counter and act accordingly |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Hi,
| sandhyaimmadi wrote: |
| what is the command to issue a COMMIT after every 1000 records. |
Do you have something differnt in mind ?
The COMMIT statement ends a unit of recovery (that's what Enrico has told) and commits the relational database changes that were made in that unit of recovery. |
|
| Back to top |
|
|
rakesha.hg
Active User
Joined: 21 Mar 2008
Posts: 161
Location: bangalore
|
|
|
|
hi Sandhya,
Do you have any examples in your shop(... doing commit differently) 
All these days .. we programmers issue commit with a commit(counter  ) ...
if you have any other ways, you have seen or in mind let the forum know. |
|
| Back to top |
|
|
|
|
