> Are you doing in-order inserts [...]? I guess I am, since these are rowid tables, with AUTOINCREMENT PKs. Or are talking about the Natural Key (NKs), using UNIQUE indexes? (those will be added later, post inserts, as discussed in this thread) > (32 MB is [...] pretty itty bitty on a computer) OK, sure. (took me a while to understand your comment, cutting through the sarcasm :)) I could afford more for sure, being on desktop as you guessed, but 64MB didn't show any improvements over 32MB, so I didn't both going any higher. Do you have evident Keith that even larger cache sizes benefit multi-GB inserts?