Android SQLCipher - Insert data will eat memory

[mic215fa]

Hi,

I use SQLCipher(Android) to store data. Every three seconds will insert 3 records.
When I use setting -> Apps -> Downloads to watch the amount of memory, I find the free space decrease.
For a test of 12 hr inserting, memory use more than 60MB. 

Although the application was not crash but I suspect it will eat more memory space after all.

I have checked the program to verify any cursor not been closed.
Does this situtation right ? Is there any thing that I need to cheek ?

Cheers,

Luke

[Nick Parker]

Hi Luke,

From your test scenario, you've inserted approximately 43,200 records

of data.  This will take storage on your device, and depending on the

configuration of your application, while running it will be resident

in memory, using RAM from the device.

Is there a specific behavior you are attempting to verify?

Nick Parker

Nick Parker

--
 
---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sqlcipher+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[mic215fa]

Dear Nick,

Supplement : We use the "adb shell" to see the db size on device. There still increase the size like memory.

We start two independent service  to process data :
One for insert data into sqlcipher. Another to query and send result to web server with schedule time.

We write the db functions in one utility java program. Something like create db , create table, insert ,query , etc.
When createing database we use :

final static String KEY = "INTEGER PRIMARY KEY AUTOINCREMENT";

For a unique key to identify records.

Should we need to  use the "PRAGMA" to turn on/off some db prameters ?

Cheers,

Luke



Nick Parker於 2013年5月17日星期五UTC+8下午10時08分12秒寫道：

[Nick Parker]

Hi Luke,

I am not sure what PRAGMA's you are referring to? Is there a specific
problem you are trying to solve?

On 5/17/13 11:46 AM, mic215fa wrote:
> Dear Nick,
>
> Supplement : We use the "adb shell" to see the db size on device. There
> still increase the size like memory.
>
> We start two independent service to process data :
> One for insert data into sqlcipher. Another to query and send result to
> web server with schedule time.
>
> We write the db functions in one utility java program. Something like
> create db , create table, insert ,query , etc.
> When createing database we use :
>
> final static String KEY = "INTEGER PRIMARY KEY AUTOINCREMENT";
>
> For a unique key to identify records.
>
> Should we need to use the "PRAGMA" to turn on/off some db prameters ?
>
> Cheers,
>
> Luke
>
>
>

> Nick Parker嚙踝蕭 2013嚙羯5嚙踝蕭17嚙踝蕭P嚙踝蕭嚙踝蕭UTC+8嚙磊嚙踝蕭10嚙踝蕭08嚙踝蕭12嚙踝蕭g嚙瘩嚙瘦

> it, send an email to sqlcipher+...@googlegroups.com <javascript:>.

> For more options, visit https://groups.google.com/groups/opt_out

> <https://groups.google.com/groups/opt_out>.

>
>
>
>
> --
>
> ---
> You received this message because you are subscribed to the Google
> Groups "SQLCipher Users" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to sqlcipher+...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

--
Nick Parker