Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    4

    Unanswered: Insert is slow in SQL 2000

    I am experiencing a problem , we have a procedure which inserts around 16000 records. It takes only 1min 15 secs in SQL 7.0, but the same procedure is taking 4 mins 50 sec in SQL 2000.
    Can anybody suggest any solution for this?

    I tried to insert 10000 in Pubs database , in SQL 7.0 it took only 15 secs while in 2000 1 min 10 secs!!!!!

  2. #2
    Join Date
    Jul 2002
    Posts
    9
    Possible answer is that you have defined more indexes in the server 2000 version of your db.

Posting Permissions

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