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
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
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
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,
Pls check if can create a normal file more than 2GB from your program
if not then some options must be missing.
regards
ragha
**
This email and its attachments contain confidential information from HUAWEI,
w
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
25 matches
Mail list logo
