Hi, We are trying to index close to one million document using documentum connector. Indexing is working fine but we see a drop in indexing performance after first day. Connector is able to index 21k/hr on the first day but it drops to 10k/hr after 24-28 hours. Although we don't see any errors and indexing is getting completed without any issue, it does take a good 2-3 days to complete indexing. As our higher environments has almost 4 times the data, we want to achieve a consistent indexing rate before going ahead.
Our Manifold is running in quick start single process model on an Linux server. Linux server has a 8 Core CPU with 16 Gig of Memory. We are using PostgreSQL as the DB. We are not sure if this is due to the size of the tables as Manifold is inserting all 1 millions document id to PorstgresDB. I can see from the DB scripts that the appropriate indexes on Tables are already getting created. Please let us know your thoughts on this. Thanks, Praveen
