Thanks for the link. Unfortunately, I was utilizing Sqlite command line executeable and not the API to do various bulk operations. Thanks, Charlie
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 21, 2004 1:26 PM To: Wardell, Charles; [EMAIL PROTECTED] Subject: Re: [sqlite] Ver 3.0 and COPY In a message dated 6/21/2004 12:31:29 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: What would be the alternative to performing bulk loads in v3.0 since the copy statement has been removed? Use precompiled sql ( http://www.sqlite.org/cvstrac/wiki?p=PrecompiledSql)and wrap inserts in a transaction is very fast. Wei ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. **********************************************************************
