process-indexing-queue is slow

CSIPiemonte

Hi,
I recently imported about 11,000 objects,
and the ca_search_index_queue table created about 2 million rows. I scheduled the ca_utils process_index_queue in cron to run every 5 minutes, checking for the existence of the lock file.

The import finished on Monday, and today, Friday, I still have about 1.6 million rows in ca_search_index_queue.

Is there a way to speed up the dequeuing? Perhaps by modifying some .conf files, such as the max_indexing_buffer_size of search.conf?

I performed the import in a dev environment with no users logged in and the system practically down, but I'm afraid that in a prod environment with more than 300 users making changes, the system will take a long time to catch up.

Thanks for your advice.
Bye Antonio.

CA 2.0.9

seth

You can reindex the whole thing, which will truncate the index queue and rebuild the index from scratch. I don't know why you'd have that many pending indexing changes, nor why it's be that slow.