Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: Slow "BCP IN" in ASE 12.5 compare to ASE 11.5

    I face very slow "BCP IN" problem in ase 12.5. I migrated database from ASE 11.5 on Sun U10 (RAM 750MB) to ASE 12.5 on Sun V880 (2 CPUs, RAM 2GB). I dump old database and load to the new one. Then I update statistics all table. After that I bcp in the remaining data from flat file. It takes about 6-9 mins to finish compare to those ase 11.5 using less than 1 min. I try to figure out what causes the problem.
    Dose anyone face this problem before? Please give me any suggestion.

  2. #2
    Join Date
    Oct 2003
    Posts
    41
    Please check your server configuration parameters like
    Procedure cache
    Data cache
    Physical memory
    Logical memory
    ====================
    Rajesh

  3. #3
    Join Date
    Nov 2003
    Posts
    2
    Originally posted by rmpathak
    Please check your server configuration parameters like
    Procedure cache
    Data cache
    Physical memory
    Logical memory
    This is my configuration parameters:

    procedure cache size 3271 12980 6000 6000 memory pages(2k) dynamic

    total data cache size 0 2310147 0 2310147 kilobytes NULL

    total physical memory 0 2394024 0 1197012 memory pages(2k) read-only

    total logical memory 48128 2409020 1204510 1204510 memory pages(2k) read-only

    Please suggest us if anyone has more ideas. Thank you.

Posting Permissions

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