Large table to be reindex
I have a large table need to be reindex .. almost 15GB
it stops sometimes as the session end and really taking long time
could it be done through CLI as background process ?
thanks
I have a large table need to be reindex .. almost 15GB
it stops sometimes as the session end and really taking long time
could it be done through CLI as background process ?
thanks
Replies
Low 20 Nov 2014 11:14
Your exp_low_search_indexes table is 15GB? That's quite large, indeed.
You can try the Build index URL to trigger the index action, see http://gotolow.com/addons/low-search/... -- but that might still cause a timeout, maybe.
You can also try to do it via the CP like you normally would, but have another window/tab with the CP open, where you can make sure the session doesn't time-out by clicking around... Not ideal, but it should work.
rootsami 21 Nov 2014 00:30
Thank you for the quick response ..
what if i change the batch size to 1000 - 10000
the table has up 1200000 records .. but thyre all texts (books) as html tags
Low 21 Nov 2014 11:55
Batch size is there to prevent server timeouts, because of the large number of queries generated by the index. You can try upping the batch size, but I don't think it will make much of a difference.
rootsami 21 Nov 2014 15:40
yeah it didnt make any difference ..
i solved the issue thou by editing EE configuration with disabling session timeout for CP .. that solved the issue and reindex all my table :)
thanx for quick support :)