Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2011
    Posts
    10

    Unanswered: Inserts are getting slower and slower

    Hi All,

    I am facing this problem when doing the inserts into the various tables within a sybase database 11.0.0.3

    the inserts are getting slower and slower as the processing progresses.
    the index and stats are same as it use to be earlier

    thanks and Regards
    Madhur

  2. #2
    Join Date
    Mar 2011
    Posts
    10
    the inserts happens fast for first 100-150 records and then slows down

  3. #3
    Join Date
    Jan 2012
    Location
    Lisbon
    Posts
    115
    Provided Answers: 1
    Hello,

    Well with indexes inserts are always slower.
    Is it a clustered index?

  4. #4
    Join Date
    Mar 2011
    Posts
    10
    Thanks Catarrunas!!,

    to elaborate more we had some corruption issue in old database so we did
    create a new database in a new server the table in question where the inserts are slower is a cut down version of the existing database

    all the stats and indexes are proper

    i see a couple of difference between old and new database

    the syslogs in new database is much low in comparsion to old
    the laod cache is not defined in new database whereas it is in new database

    can any of these be the reason of slowness

  5. #5
    Join Date
    Mar 2011
    Posts
    10
    load_cache is a named cache, is there any optimization required say between selects and load in the cache

  6. #6
    Join Date
    Jan 2012
    Location
    Lisbon
    Posts
    115
    Provided Answers: 1
    Hello,

    If you have small syslogs, it will fill more quickly. I assume your doing a bcp out and bcp in.

    What you can do, if not done already, is configure this option "trunc log on chkpt" in order to truncate the syslogs everytime a chekpoint occurs. ( 50 lines inserted or once per minute). This way you should have the syslogs with low usage.

    In my opinion you should also remove your indexes to insert the rows. After the insertion recriate them.
    This way you get a fast bcp in. Otherwise with indexes you won't.

    About that named cache, it won't help you on inserts just on work on that db, queries, temporary tables, indexes creation...
    Did you bind that named cache ?
    sp_helpcache - check cache binding information.

    Hope it helps
    Last edited by Catarrunas; 07-02-12 at 13:52.

Posting Permissions

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