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-perform...
Is the performance ok if you just commit a fuel-ed collection to a blob field?
Stephan