DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Help needed on Periodic commits

  1. 05-31-2001, 02:28 PM #1
    hemanr
    hemanr is offline Senior Member
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262

    Red face

    Hi gurus,
    I have a procedure which inserts 3 million records and commits only at the end.
    Due to obvious performance problems I need to put in commits after say, every 10000 records are inserted.
    Can anyone help me out?

    Thanks a deal.
    Hemant
    Reply With Quote Reply With Quote
  2. 05-31-2001, 02:54 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    There are lots of examples on this site. For example,
    http://www.dbasupport.com/forums/sho...?threadid=5708
    Jeff Hunter
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width