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
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
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
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
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
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
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[_]
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
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
9 matches
Mail list logo