[sqlite] possible optimization to sqlite3BtreeMoveto

I've been working with SQLite 3.2.1 and trying to do database creation as fast as possible. In my situation, I've been using auto-incremented key values. One thing that I've noted is that a fair amount of time was being spent in sqlite3BtreeMoveto(). As I understand it, the general algorithm

Re: [sqlite] optimizing database creation speed

code which I'll mention in a separate post. Thanks to all who replied. --Chuck Pahlmeyer Al Danial wrote: On 7/21/05, Chuck Pahlmeyer - MTI <[EMAIL PROTECTED]> wrote: I have an application in which I'd like to create a database as quickly as possible. The application h

[sqlite] optimizing database creation speed

I have an application in which I'd like to create a database as quickly as possible. The application has a batch process at startup which creates the data. I am using a single transaction for all of the INSERT statements. I'm also using prepared statements to alleviate some of the overhead for pro