Comment 6 for bug 1727557

Revision history for this message
Jeff Davis (jdavis-sitka) wrote :

We're currently doing one insert for each line of the block list, which isn't very efficient. But even if we insert multiple rows at once, it sounds like we'll run into problems with large lists. From section 2.3 of the Lovefield design doc:

"If the database has more than 10K rows in a single table, users need to consider using experimental bundled mode to improve app loading time."

That 10K row limit will be insufficient in many cases. (Sitka's block list currently has 564K entries!)

Bundled mode is described in section 2.3.2:
https://github.com/google/lovefield/blob/master/docs/dd/02_data_store.md#232-bundled-mode-experiment

Instructions for enabling bundled mode are described elsewhere:
https://github.com/google/lovefield/blob/master/docs/spec/99_postfix.md

Something to explore?