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
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
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
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
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
When I look at the structure of the created database-file, the rows for the
t
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]>
I've been fooling with 3.1.3 tonight and hex dumped one of my database
files:
[EMAIL PROTECTED] itemlist]$ hexdump -C -n 16 wishlist
53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 |SQLite
format 3.|
0010
Only the first 16 bytes are shown here. Is there a published file
structu
7 matches
Mail list logo
