On Tue, 17 Feb 2009 19:11:56 +0100, Kees Nuyt
wrote in sqlite-users@sqlite.org:
I'm not fond of replying to myself, but this needs some
clarification:
>- Try to use integers as primary key,
> make it the first column, << wrong
> and use the exact code
> CREATE TABLE tablename (
> column
On Mon, 16 Feb 2009 20:02:11 -0800 (PST), jaya_kumar
wrote in General
Discussion of SQLite Database :
>
>Hi All,
>
>In the following use case, when I try to update the following number of
>objects SQLite DB file size is very large
>
>1. 1k object - DB file size was 264 Kb
>2. 41k object - DB file
Didn't you ask this question 4 days ago, and it was answered? The only
difference in your question this time around seems to be that you are
asking for a way to reduce the db file size. You could utilize a
compression library on your data... check the mail archives and also
google for that informat
Hi All,
In the following use case, when I try to update the following number of
objects SQLite DB file size is very large
1. 1k object - DB file size was 264 Kb
2. 41k object - DB file size was 11 Mb
3. 100k object - DB file size was 26 Mb
Is there any way to reduce the DB file size?
Thanks in
On Thu, 12 Feb 2009 19:14:44 -0800 (PST), jaya_kumar
wrote in General
Discussion of SQLite Database :
>
>I am trying to find the peak heap usage for creating a table with few entries
>and when calculated the peak heap usage increases as the numbers of items
>inserted into the table increases.
>
>
I am trying to find the peak heap usage for creating a table with few entries
and when calculated the peak heap usage increases as the numbers of items
inserted into the table increases.
Following are the steps done,
1. Table created
2. Table updated by insert statement
3. Query for a single tupp
6 matches
Mail list logo
