Hi Again Robert,
I have run your program on the CE emulator (Pocket PC 2003) and i got the same
memory leak.
I have inserted 2 buttons on a MFC dialog application.
The first button executes your code and the second button closes the
application.
If you examine the memory you will discover that the program only free the
memory once you exit from the apllication, meanwhile it reserves memory as its
needed (on demand, but see details below).
the memory behaviour of SQLite is quite strange, an example:
lets say that a select sentence reserves 1000kb of memory, once this local
process has finished memory keeps reserved for the program (it should be
freed), if another process executes a select sentence that needs 200kb SQLite
will not reserve 200k more, it will use 200k of the previous 1000k reserved. if
a 3rd process executes a select sentence that needs 1300k SQlite will reserve
300kb more and those 1300kb will not be freed until the main dialog application
closes (even if the 3 process where local methods or functions).
The problem is that if a select sentence consume most of the memory it will not
be freed and the program will execute very slow until you exit from the
application because there will be so little memory left for other not SQLite
process that the program might be unusable.
Any ideas,
Thank you in advance
Eduardo
---Mensaje original---Ok, here's what I did ...
On the desktop I created a SQLite database with one table and inserted
120,000 rows into it. I then copied it over to the CE emulator.
Then I ran the following code on the CE (Pocket PC 2003 SE) emulator:
#include
#include
#include "sqlite3.h"
int WINAPI _tWinMain(HINSTANCE hInst, HINSTANCE hPrev, LPTSTR pszCmdLine,
int nCmdShow)
{
sqlite3 *pdb;
int rc;
for (int n = 0; n < 10000; n )
{
rc = sqlite3_open("\\test.db3", &pdb);
if (rc) break;
rc = sqlite3_exec(pdb, "select * from testcase", 0, 0, 0);
if (rc) break;
rc = sqlite3_close(pdb);
if (rc) break;
}
return 0;
}
On the first call to sqlite3_exec(), available program memory dropped from
an initial 10.5mb to 8.45mb. However, once that was done, available memory
remained rock solid for the duration of the loop at a constant 8.45mb and no
non-zero error codes were ever returned.
Robert
El día del padre está cerca... ¿Ya tienes el regalo?
http://buscawanadoo.es/search?type=pref&destino=web&origen=homespot&buscar=Regalos%20Día%20del%20Padre
