[sqlite] sqlite3 not support write and read at the same time?

2018-05-02 Thread king3306
HI every one i use sqlite3 3.22.0 verison on embeded arm9 system when i insert a lot of data like this begin_transaction sqlite3_prepare_v2(); for(i = 0;i<2040;i++) { sqlite3_bind_text(); sqlite3_bind_blob(); sqlite3_step(); sqlite3_reset(); sqlite3_clear_bindings(); }

[sqlite] what sqlite3_memory_used mean ?

2018-04-14 Thread king3306
HI I use sqlite3 on embedded arm my memory is very small free memory about 6M so i want to use MEMSYS5 to limit memory use i define DSQLITE_ENABLE_MEMSYS5=1 in sqlite3.c compile it in my code start i use

[sqlite] what sqlite3_memory_used mean ?

2018-04-14 Thread king3306
HI I use sqlite3 in embedded arm my memory is very small about 4M so i want to use MEMSYS5 to limit memory use i define DSQLITE_ENABLE_MEMSYS5 1 in sqlite3.c compile it in my code start i use sqlite3_config(SQLITE_CONFIG_HEAP,malloc(2*1024*1024),2*1024*1024);

[sqlite] what sqlite3_memory_used mean??

2018-04-14 Thread king3306
HI I use sqlite3 in embedded arm my memory is very small about 4M so i want to use MEMSYS5 to limit memory use i define DSQLITE_ENABLE_MEMSYS5 1 in sqlite3.c compile it in my code start i use sqlite3_config(SQLITE_CONFIG_HEAP,malloc(2*1024*1024),2*1024*1024);

Re: [sqlite] memory leak?

2018-04-12 Thread king3306
first thanks you reply After running for some time i found sqlite3_memory_used return value keep constant about 2M,but linux free memory is fewer and fewer,i make sure no other places are leaked,why? this whether or not a normal behavior? if not ,how can i to analysis this problem? Looking

Re: [sqlite] memory leak?

2018-04-12 Thread king3306
my platform is armv5 not support valgrind and lint, can you help me ? -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] memory leak?

2018-04-12 Thread king3306
thans your reply , when find the problem,i try to use valgrind tool,but i find this tools is not support armv5,i use mcu is AT91SAM9G25 -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list

Re: [sqlite] memory leak?

2018-04-12 Thread king3306
sorry i made a mistake SQLite version 3.3.6 is linux built-in sqlite3 i use is SQLITE_VERSION"3.22.0" on arm -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] memory leak?

2018-04-12 Thread king3306
HI I am use SQLite version 3.3.6 default page_size is 4096 , i set 1024 i have four question ,i don't understand 1: before i use insert cmd ,the linux memory and sqlite3_memory_used is linux: tota=29126656 used=16998400 free=12128256 sqlite3_memory_used:1372576 after i use inset cmd ,the