Re: [sqlite] Database File Size

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

Re: [sqlite] Database File Size

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

Re: [sqlite] Database File Size

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

Re: [sqlite] Database File Size

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 >

[sqlite] Database File Size

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.

Re: [sqlite] Database file size

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

Re: [sqlite] Database file size

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 SQLi

Re: [sqlite] Database file size

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 but perhap

Re: [sqlite] Database file size

gt; 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 >>

Re: [sqlite] Database file size

] 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 > SQ

Re: [sqlite] Database file size

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]

Re: [sqlite] Database file size

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 playing around

Re: [sqlite] Database file size

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 playing around

Re: [sqlite] Database file size

and 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

Re: [sqlite] Database file size

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

[sqlite] Database file size

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!

Re: [sqlite] database file size isn't really very small

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

Re: [sqlite] database file size isn't really very small

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

Re: [sqlite] database file size isn't really very small

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

Re: [sqlite] database file size isn't really very small

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

Re: [sqlite] database file size isn't really very small

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

[sqlite] database file size isn't really very small

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

Re: [sqlite] Database file size

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

Re: [sqlite] Database file size

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,

[sqlite] Database file size

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

Re: [sqlite] Database File size not exceeding 2GB

; 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

[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 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

Re: [sqlite] Database File size not exceeding 2GB

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

Re: [sqlite] Database File size not exceeding 2GB

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

[sqlite] SQLite Database File Size

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