User Tools

Site Tools


notes:sqlite_scaling

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
notes:sqlite_scaling [2013/03/13 16:37]
andy [SQLite Scaling]
notes:sqlite_scaling [2013/03/13 16:37] (current)
andy [SQLite Scaling]
Line 66: Line 66:
 ^ 10000 | 14.84 | 13.99 | ^ 10000 | 14.84 | 13.99 |
 ^ 100000 | 159.72 | 1539.56 | ^ 100000 | 159.72 | 1539.56 |
-^ 1000000 | :?:   | :?:     | 
  
 It appears that the insertion time is scaling roughly linearly with the number of operations, but the query time is increasing at a steeper rate. This probably isn't surprising since table scans are required. It appears that the insertion time is scaling roughly linearly with the number of operations, but the query time is increasing at a steeper rate. This probably isn't surprising since table scans are required.
notes/sqlite_scaling.1363192649.txt.gz ยท Last modified: 2013/03/13 16:37 by andy