Re: [sqlite] Database file structure

2011-10-23 Thread Fabian
2011/10/23 Simon Slavin > > In that case, try defragging your file sometime. May make a big > difference. > > If you mean Windows defrag, it would be pointless, since it doesn't change the database structure? If you mean VACUUM, it will generate the exact same structure as 'method 2', so I could

Re: [sqlite] Database file structure

2011-10-23 Thread Simon Slavin
On 23 Oct 2011, at 4:03pm, Fabian wrote: > It's Windows/NTFS, but I get the point. In that case, try defragging your file sometime. May make a big difference. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] Database file structure

2011-10-23 Thread Fabian
2011/10/23 Simon Slavin > > My immediate question is why this is two rows in two separate tables rather > than one row in one table. After all, if tables always have the same rows > in, they might as well be the same row in one table. I would love to have those rows into a single table, becaus

Re: [sqlite] Database file structure

2011-10-23 Thread Simon Slavin
On 23 Oct 2011, at 3:41pm, Fabian wrote: > I have two tables, both containing 1 million rows, which frequently need to > be joined by rowid. Right now, the insert loop is like this: > > For I = 1 to 1000 > INSERT INTO TABLE1 ... > INSERT INTO TABLE2 ... > Next [snip] My immediate qu

Re: [sqlite] Database File Structure

2005-02-27 Thread D. Richard Hipp
On Sun, 2005-02-27 at 22:54 -0500, Robert L Cochran wrote: > Is there a published file > structure for the database? > The header comment to the btree.c source file. http://www.sqlite.org/cvstrac/getfile/sqlite/src/btree.c -- D. Richard Hipp <[EMAIL PROTECTED]>