Dear Stephan,

Thanks for your quick answer and your pretty detailed information on SQLite optimization. Because my data was taken from several files, what I did was to split the importation into the database in several batches of 10 files at the time. That did it.

Cheers,

Offray

On 08/11/15 17:39, Stephan Eggermont wrote:
On 08/11/15 22:55, Offray Vladimir Luna Cárdenas wrote:
In fact seems that my problem is not that. Is to storage a "large"
Smalltalk collection (10k items) in a SQLite database. When I try to do
it the environment becomes unresponsive. Any hint on how to do it is
welcomed.

How are you using SQLite? You might get some improvement ideas from
http://stackoverflow.com/questions/1711631/improve-insert-per-second-performance-of-sqlite

Is the performance ok if you just commit a fuel-ed collection to a blob field?

Stephan





Reply via email to