Re: [sqlite] Is it possible to optimize the readperformanceofa C++ app using sqlite pragma journal_mode = wal

2011-05-29 Thread Michael Stephenson
If you change the page size after the database has been created and written to, yes, you need to a vacuum to have SQLite reorganize the database pages. Note that even this does not work if WAL is in use (if WAL is turned on, then you can't change the database page size after the database has been

Re: [sqlite] Is it possible to optimize the readperformanceofa C++ app using sqlite pragma journal_mode = wal

2011-05-29 Thread Simon Slavin
On 30 May 2011, at 2:08am, Frank Chang wrote: > Thank you for your help with the PRAGMA page size question. Sometimes I see > C++ programs which first issue the PRAGMA page_size = 4096. Then these C++ > programs request a sqlite3_execute(Database,"VACUUM",callback,0,) which > takes about 4

Re: [sqlite] Is it possible to optimize the readperformanceofa C++ app using sqlite pragma journal_mode = wal

2011-05-29 Thread Frank Chang
Simon Slavin, Thank you for your help with the PRAGMA page size question. Sometimes I see C++ programs which first issue the PRAGMA page_size = 4096. Then these C++ programs request a sqlite3_execute(Database,"VACUUM",callback,0,) which takes about 4 minutes to complete. We

Re: [sqlite] Cannot load SQLite.Interop.dll but file is in the folder

2011-05-29 Thread Black, Michael (IS)
Welcome to DLL hell...Microsoft keeps changing it... http://msdn.microsoft.com/en-us/library/ms682586(v=vs.85).aspx Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate From: sqlite-users-boun...@sqlite.org

[sqlite] Cannot load SQLite.Interop.dll but file is in the folder

2011-05-29 Thread Cyrille
Dear all, One of the users of my application has a critical issue. When he launches it, he gets an error message "Impossible to load DLL "SQLite.Interop.DLL". However, the file is in the same folder as the EXE one. Stranger: he sent me the whole folder and the application runs very well from

Re: [sqlite] Bulk insert performance

2011-05-29 Thread Joe D
On 2011-05-29 06:14, Kees Nuyt wrote: > On Sun, 29 May 2011 10:35:51 +1000, "Greg Keogh" > wrote: > >> I'm utterly gobsmacked by the poor performance of the >> inserts without a transaction around them. > > It's a FAQ, > http://www.sqlite.org/faq.html#q19 > explains the reasons

Re: [sqlite] Bulk insert performance

2011-05-29 Thread Kees Nuyt
On Sun, 29 May 2011 10:35:51 +1000, "Greg Keogh" wrote: > I'm utterly gobsmacked by the poor performance of the > inserts without a transaction around them. It's a FAQ, http://www.sqlite.org/faq.html#q19 explains the reasons quite clearly. -- ( Kees Nuyt ) c[_]

[sqlite] Bulk insert performance

2011-05-29 Thread Greg Keogh
Hello team, this isn't really a bug report, it's just a heads-up about a trap for new players. I've just started evaluating the SQLite 1.0.66.0 ADO.NET provider, and I'm most impressed by the whole experience. For your possible interest I have pasted below a copy of a post I just made into the

Re: [sqlite] Unlocking the database

2011-05-29 Thread Christoph P.U. Kukulies
Am 28.05.2011 18:39, schrieb john darnell: > I was/am using Windows XP SP3. Sorry, but the company is extremely > conservative in upgrade policies. > > Hmmm > You may want to use PROCMON (formerly FILEMON from sysinternals.com) ( http://technet.microsoft.com/en-us/sysinternals/bb896645) to