e bulk insert speed observations when page_size and
cache_size are varied
The bash script below attempts to quantify the relationship between
SQLite (3.5.0 alpha) page_size and cache_size towards the speed of
populating a large table with many indexes.
First some rough metrics on the
TED]>
Date: Tuesday, September 18, 2007 8:28 pm
Subject: [sqlite] large bulk insert speed observations when page_size and
cache_size are varied
> The bash script below attempts to quantify the relationship between
> SQLite (3.5.0 alpha) page_size and cache_size towards the speed of
> pop
The bash script below attempts to quantify the relationship between
SQLite (3.5.0 alpha) page_size and cache_size towards the speed of
populating a large table with many indexes.
First some rough metrics on the final populated database:
The database is approximately 208M in size, consisting of a
3 matches
Mail list logo