Regarding: "Is there away to maximize this speed dramatically ...?"
Yes, be sure to surround your inserts with a single transaction (i.e., "BEGIN", "END"). If you were doing millions of inserts, you might want to use a new transaction after each, say, 5 thousand inserts. If you don't care about the integrity of your database in the event of a crash (i.e., you'll just repeat the build from scratch) you might turn off SYNCHRONOUS with the PRAGMA, but just using the transaction might be quite sufficient. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------