On 30 Aug 2013, at 5:37am, techi eth wrote:
> I am using Jffs2 file system. As of now I using all default from
> sqlite3.I am not sure with this information it is possible to get some
> approx that with 'X KB data, database file size will be 'Y' KB or MB.
Your best way to figure this out is to
I am thinking to use auto_vacuum INCREMENTAL & PRAGMA
incremental_vacuum(N) to make sure whenever required, pages can be
free.
I assume this will be better option with compare to FULL.
I assume i can do anytime this operation in squence after opening
successfull connection to Database.I am holdin
I am using Jffs2 file system. As of now I using all default from
sqlite3.I am not sure with this information it is possible to get some
approx that with 'X KB data, database file size will be 'Y' KB or MB.
> Regarding default file size.
I understand with the use of max_page_count & size of each pa
On 29 Aug 2013, at 9:11am, techi eth wrote:
> 1) Is their any way I can calculate approx file size based on data.
>
> Ex : Let us say i am creating table with (row ID int ,Test Text).
>
> Each text string size is 10 byte. If I will create 100 row of this in
> database then what would be
Database files size:
1) Is their any way I can calculate approx file size based on data.
Ex : Let us say i am creating table with (row ID int ,Test Text).
Each text string size is 10 byte. If I will create 100 row of this in
database then what would be Max size of created database file.
On Thu, Nov 27, 2008 at 08:12:02AM +, Simon Bulman wrote:
> Morning,
>
> Table 1
>
> BIGINT (index), VARCHAR(30), VARCHAR(10)
>
>
>
> Table 2
>
> BIGINT (index), FLOAT
For the second table, the index will contain the BIGINT value and the table
rowid, which is almost as big as the actu
suspect you will need to develop a proprietary one-off solution, as
you have done.
>
>
> Cheers,
> S.
>
> -Original Message-
> From: Jens Miltner [mailto:[EMAIL PROTECTED]
> Sent: 28 November 2008 12:58
> To: [EMAIL PROTECTED]
> Cc: 'General Discussion of
PROTECTED]
Cc: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Database file size
Am 28.11.2008 um 13:37 schrieb Simon Bulman:
> Ahhh, sorry, I wrongly calculated the number of rows in table 2. It
> actually
> has 29581 rows. Still surprised at the 7x size increase
ng info,
>
> Cheers,
> S.
>
> -Original Message-
> From: Jens Miltner [mailto:[EMAIL PROTECTED]
> Sent: 28 November 2008 08:38
> To: [EMAIL PROTECTED]
> Cc: General Discussion of SQLite Database
> Subject: Re: [sqlite] Database file size
>
>
> Am 28.11.2008 um
08 08:38
> To: [EMAIL PROTECTED]
> Cc: General Discussion of SQLite Database
> Subject: Re: [sqlite] Database file size
>
>
> Am 28.11.2008 um 09:20 schrieb Simon Bulman:
>
>> Hi Jens,
>>
>> Thanks for your input. UTF-8 did not make a difference. I expecte
]
Sent: 28 November 2008 08:38
To: [EMAIL PROTECTED]
Cc: General Discussion of SQLite Database
Subject: Re: [sqlite] Database file size
Am 28.11.2008 um 09:20 schrieb Simon Bulman:
> Hi Jens,
>
> Thanks for your input. UTF-8 did not make a difference. I expected
> that
> SQLit
Download the sqlite3_analyzer.exe utility from the SQLite website
(http://www.sqlite.org/download.html
) and run it against your database file. The output will tell you
where the disk space is being used. You might want to post the output
to this list.
D. Richard Hipp
[EMAIL PROTECTED]
sage-
> From: Jens Miltner [mailto:[EMAIL PROTECTED]
> Sent: 27 November 2008 13:48
> To: General Discussion of SQLite Database
> Cc: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Database file size
>
>
> Am 27.11.2008 um 09:12 schrieb Simon Bulman:
>
>> I have been
sage-
> From: Jens Miltner [mailto:[EMAIL PROTECTED]
> Sent: 27 November 2008 13:48
> To: General Discussion of SQLite Database
> Cc: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Database file size
>
>
> Am 27.11.2008 um 09:12 schrieb Simon Bulman:
>
>> I have been
recreate)
programmatically so vacuuming has not effect.
Cheers,
S.
-Original Message-
From: Jens Miltner [mailto:[EMAIL PROTECTED]
Sent: 27 November 2008 13:48
To: General Discussion of SQLite Database
Cc: [EMAIL PROTECTED]
Subject: Re: [sqlite] Database file size
Am 27.11.2008 um 09:12
Am 27.11.2008 um 09:12 schrieb Simon Bulman:
> I have been playing around with SQLite to use as an alternative to
> one of
> our proprietary file formats used to read large amounts of data. Our
> proprietary format performs very badly i.e. takes a long time to
> load some
> data; as expected
Morning,
I have been playing around with SQLite to use as an alternative to one of
our proprietary file formats used to read large amounts of data. Our
proprietary format performs very badly i.e. takes a long time to load some
data; as expected SQLite is lighting quick in comparison - great!
Ah, ha! I had actually originally planned on doing that but when I read the
primary key could only be an integer I assumed it was a 32 bit integer so I
would need a separate column for the date. But you're right of course and I
see now that as of version 3, I can use 64 bit integers as the primary
Try making your date a REAL and using the Sqlite date and time
functions. You will use extra space for the rowid, the key of the row
and for the b-tree index.
You would expect the indexed rows to be about double the raw text data
since the numbers are 64 bit FP.
Corey Nelson wrote:
> I'm deve
Not really two copies as the integer could be primary key ...
something along the lines of
CREATE TABLE StockName (date INTEGER PRIMARY KEY, price REAL);
Regards,
F.
On Fri, Jul 18, 2008 at 10:03 PM, Jay A. Kreibich <[EMAIL PROTECTED]> wrote:
> On Fri, Jul 18, 2008 at 11:58:16AM -0700, Corey Nel
On Fri, Jul 18, 2008 at 11:58:16AM -0700, Corey Nelson scratched on the wall:
> > sqlite3 Ticks.db ".dump"
> BEGIN TRANSACTION;
> CREATE TABLE StockName (date TEXT UNIQUE ON CONFLICT REPLACE, price REAL);
> I would expect the database file to store a bit of "extra" data but it's
> 2.17 times bigge
Corey Nelson <[EMAIL PROTECTED]>
wrote:
> It didn't take me long to get some test data into an SQLite3 database
> file. But there's a problem, the database file is almost three times
> bigger than storing the information in text files the way I had
> planned.
Well, you can't get something for noth
I'm developing some software that helps with day trading. I need to store
years worth of tick prices. At first I was going to write a library that
would write and read this information to and from files. Then I thought
"don't be silly", this is the sort of thing databases were made for. I have
litt
Do you know how I can determine programatically if the database has a lot of
empty space? For example how i can determine if 30% of the data space is
empty?
Trey Mack wrote:
>
>
>> I add records to database tables. Then when i delete them the database do
>> not
>> reduce size. I add BLOB elem
I add records to database tables. Then when i delete them the database do
not
reduce size. I add BLOB elements. Do you know what can be the problem?
Thanks
http://www.sqlite.org/lang_vacuum.html
-
To unsubscribe,
I add records to database tables. Then when i delete them the database do not
reduce size. I add BLOB elements. Do you know what can be the problem?
Thanks
--
View this message in context:
http://www.nabble.com/Database-file-size-tf4666479.html#a13330175
Sent from the SQLite mailing list archive
;
Date: Thursday, July 5, 2007 7:37 pm
Subject: [sqlite] Database File size not exceeding 2GB
> Hi all,
>
>
>
> This is with reference to the problem mentioned below:
>
>
>
> 1) I am using NTFS file system
>
> 2) I tried in windows 2000 and Windows X
Hi all,
This is with reference to the problem mentioned below:
1) I am using NTFS file system
2) I tried in windows 2000 and Windows XP
But still I am able to log only 2 GB of data. SQLite stops logging data
more than that. But it is not throwing any exception also.
Is
According to http://en.wikipedia.org/wiki/File_Allocation_Table , the limit
on FAT16 is 2 gigabytes per file, on FAT32 it's 4 gigabytes per file, and on
NTFS it's very, very large.
In my application I needed to deal with splitting my data into 2 gigabyte
(maximum) database file sizes, and I had t
Is the file system holding your file Fat32, or NTFS? If it's Fat32, it may
be the source of your problem, as it doesn't support very large files.
Ian
On 7/4/07, Krishnamoorthy, Priya (IE10) <[EMAIL PROTECTED]>
wrote:
Hi all,
I am using SQLite3 database in my application.
My application
Hi all,
I am using SQLite3 database in my application.
My application runs on Windows XP (32 bit) platform. I am not able to
store more than 2GB of data in my database. Is it not possible to store
more than 2gb data in windows XP?
I used SQlite3 in Linux and could store more than 2GB.
[EMAIL PROTECTED] wrote:
Hi,
I have started to use SQLite recently. I have an interesting situation of
deciding the database schematic for my solution. In one of the tables I
need to store contents of size 2000 * 20. If I could create 4 rows
containing only one or two columns, my schema is q
Hi,
I have started to use SQLite recently. I have an interesting situation of
deciding the database schematic for my solution. In one of the tables I
need to store contents of size 2000 * 20. If I could create 4 rows
containing only one or two columns, my schema is quite convenient and
ext
33 matches
Mail list logo