I am doing a loading test on alfresco recently, 4 million of pdf documents are inserted into alfresco .But recently the insertion process became very slow.Before total document size less than 3 million,it take 1minute to do 160 pdf insertions.After total document size larger than 3 million,it takes 3-4 minutes to do 160 pdf insertions.
I have no idea what is going on.Any one have suggestions?
I guess this would apply to : if you have index inside a table, more indexes means faster search but slower insertation because takes time to update indexes.