Simon Davies wrote: > Compiled your snippet using VS2005 on XP, sqlite 3.4.2 - > ran to completion with no errors
Yeah, I had no errors when I ran this using the native exports from the System.Data.SQLite.dll .NET wrapper from http://sqlite.phxsoftware.com This also uses the 3.4.2 library. I can only assume there's a problem with the 3.5.* lib somewhere when bulk filling in this manner. > PS Took nrly 2 hrs. Added "BEGIN" and "COMMIT" around insert loop, > reduced time to 10 seconds Yeah, it's a long way of filling but I needed to test it in this way as it'd be filled up by single queries in the real world Thanks, Ged. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------