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

the inserts happens fast for first 100-150 records and then slows down

Hello,

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

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

load_cache is a named cache, is there any optimization required say between selects and load in the cache

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