Hi, > Maybe experiment with doing batches of inserts followed by a limit=0 > view query to refresh the index.
We do this for all our inserts. It really does make a big difference - if I just bulk insert when stress-testing without refreshing the views, my laptop grinds to a halt. However, if I refresh the view after a bulk insert, everything's hunky-dory. Regards, James.
