Sean Heber wrote:
I've been inserting data into a table with a non-integer primary
key. The data does not come in in an ordered fashion. My thought is
that perhaps performance suffers because it needs to rewrite huge
chunks of the data file in order to slot the new data into its
correct position within the file based on the sorting of the primary
key.
That makes sense, okay. Perhaps my problem is that my data is too
big. Is a page around 1k? I often insert blob data in the 64k range.
Perhaps that is my problem.
My experience is that for chunks of data that are above something like
20K, you're better off (performance-wise) writing to separate,
individual files than using SQLite blobs.
-Eric
- Re: [sqlite] Write performance Eric Scouten
-
