Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2002
    Location
    India
    Posts
    38

    Unanswered: How many records can handle?

    hi to all
    I have a replication procedure in my ASP file and also i am using the stored procedure for inserting records.

    My doubt is i have 67500 records in my Text file. I am trying to insert each line into my sqlserver dB.

    Sqlserver can handle this replicaton..?
    -- Prasad --

  2. #2
    Join Date
    Jul 2002
    Posts
    10

    May be will help...

    I don't know if this will help, but as a comparison, we have a few upload processes written in Cold Fusion that takes various files (including CSV, Excel, and Text) and inserts/updates records on the fly in one of our SQL Server databases, and the records inserted/updated are in the upper limits of 100,000 per file.

    Couple things to think about:

    1) Make sure that you have identified a long time-out period in your ASP script, since that will affect the processing time, meaning that if you don't increase the time threshold in your script, than the script will probably time out.

    2) Make sure that you set your SQL Server for a longer time-out period for receiving requests.

    Q: Are you planning on running this process in the background, like as a Scheduled Task -or- is this is a script you'll be running from the web browser?

  3. #3
    Join Date
    Feb 2002
    Location
    India
    Posts
    38
    When i submit the form it has to be generate and save it into Database. so upto that the form should be appering in same position.
    -- Prasad --

  4. #4
    Join Date
    Jul 2002
    Posts
    10
    Originally posted by buddu
    When i submit the form it has to be generate and save it into Database. so upto that the form should be appering in same position.
    Sorry, I don't understand your response. Could you provide more details about your end goals of this particular project?

Posting Permissions

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