Results 1 to 3 of 3

Thread: bcp

  1. #1
    Join Date
    Jul 2003
    Posts
    11

    Unanswered: bcp

    Dear All,
    Problem : I want to bcpin 10 millions rows into a table.

    But before that I have to decide whether I go with fast BCP or Slow BCP.
    I have to find out the trade off between using fast bcp and creating the indexes afterward or
    Using Slow Bcp without droping indexes.

    For this purpose I need the following details:-
    a. Is there any way by which we can calculate the time particular index take to create?
    b. I mean what are the factors which we have to consider for coming to the conclusion of using slow bcp or bcp

    Iam Using ASE12.5.0.3 ESD#3 on Sun Solaris
    Thanks & Regards
    Lalit

  2. #2
    Join Date
    Dec 2002
    Posts
    104

    Re: bcp

    Originally posted by suraj_c
    Dear All,
    Problem : I want to bcpin 10 millions rows into a table.

    But before that I have to decide whether I go with fast BCP or Slow BCP.
    I have to find out the trade off between using fast bcp and creating the indexes afterward or
    Using Slow Bcp without droping indexes.

    For this purpose I need the following details:-
    a. Is there any way by which we can calculate the time particular index take to create?
    b. I mean what are the factors which we have to consider for coming to the conclusion of using slow bcp or bcp

    Iam Using ASE12.5.0.3 ESD#3 on Sun Solaris
    Thanks & Regards
    Lalit
    just a lil addition

    if u do slow BCP, it will log ....so ur transaction log will get filled up very easily...as u have to insert 10 million records.

    It is always recommended to do fast BCP on large table....
    As u urself said fast BCP means dropping the index on table first and then BCP and then recreating index on the table..

    and if index is clustered index...then with each insert it will update the index...which requires 120% of ur table space...and overhead increases exponentially.

    if u weigh between slow BCP and fast BCP ...fast BCP wud be better in this case (as far as i know)

    --Pooja

  3. #3
    Join Date
    Jul 2003
    Posts
    11

    bcp

    Thanks Pooja for replying,
    What exactly i want to know the formula by which i can find out the timing ,each index going to take to built.
    Thanks & Regards
    Suraj

Posting Permissions

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