Fine tunning (Adding,deleting)

Results 1 to 2 of 2

Thread: Fine tunning (Adding,deleting)

  1. #1
    Join Date
    Dec 1969

    Default Fine tunning (Adding,deleting)

    My requirement is to delete all the existing record in database first, then add all the new record from text delimited file to database.<BR><BR>When i used normal recordset(ADO) to do this..It take totally 1 minutes to delete 3000 records from database and add 3000 record again to database.I think using INSERT or stored procedure would be faster.Anyway I found that DTS is the faster way to accomplish this but i got no idea how to call it from asp.Thanks in advance for your help. <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Fine tunning (Adding,deleting)

    i have heard something about DMO,maybe it can help.

Posting Permissions

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