Re: [sqlite] Disk file size

2012-06-06 Thread Simon Slavin
On 6 Jun 2012, at 12:42pm, vallur raghava reddy wrote: > I have created a database "MyDb.db" and created a table MyTable using > the query *create table MyTable (id INTEGER PRIMARY KEY, value > CHARACTER(10))* and inserted 3000 records in the table.I executed

Re: [sqlite] Disk file size

2012-06-06 Thread Black, Michael (IS)
om: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of vallur raghava reddy [vallur.raghavare...@gmail.com] Sent: Wednesday, June 06, 2012 6:42 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Disk file size Hi, I have created a database "MyDb.db"

Re: [sqlite] Disk file size

2012-06-06 Thread John Drescher
On Wed, Jun 6, 2012 at 7:42 AM, vallur raghava reddy wrote: > Hi, >     I have created a database "MyDb.db" and created a table MyTable using > the query *create table MyTable (id INTEGER PRIMARY KEY, value > CHARACTER(10))* and inserted 3000 records in the table.I

[sqlite] Disk file size

2012-06-06 Thread vallur raghava reddy
Hi, I have created a database "MyDb.db" and created a table MyTable using the query *create table MyTable (id INTEGER PRIMARY KEY, value CHARACTER(10))* and inserted 3000 records in the table.I executed query *select * from MyTable* it returned 3000 rows and was able to print all values. Now