[sqlite] What happens with ROWID when doing a "INSERT INTO somenewdb SELECT * FROM someolddb"

Hi, I have found the possibility of using CREATE TABLE some_new_table INSERT INTO some_new_table SELECT * FROM some_old_table_with_same_layout; to be extremely useful to recreate databases. Since ROWID is a hidden field of every table: will sqlite copy over the identical

Re: [sqlite] page size and record packing

Am 26.01.2006 um 02:54 schrieb [EMAIL PROTECTED]: deminix <[EMAIL PROTECTED]> wrote: I was curious if a single page of the database was limited to at most one record, aka can records be packed into a single page? Multiple small records can fit on one page. Or a large record can span

Re: [sqlite] More columns vs. several tables

Am 02.05.2006 um 18:46 schrieb [EMAIL PROTECTED]: Felix Schwarz <[EMAIL PROTECTED]> wrote: I'm wondering whether there is a big performance hit for a simple SELECT binarydata FROM entries WHERE somehash = 27817298; when I use CREATE TABLE entries( en

[sqlite] More columns vs. several tables

Hi, I have to decide on a table layout for storing the data of my upcoming project. Yesterday I have made my way through the excellent presentation at http://www.sqlite.org/php2004/page-036.html and read the sentence "Put small and frequently used columns early in the table to minimize

[sqlite] sqlite3_finalize() thread-safety (was: Re: [sqlite] Direct use of SQLite btree functions / performance)

Am 19.04.2006 um 15:31 schrieb [EMAIL PROTECTED]: Felix Schwarz <[EMAIL PROTECTED]> wrote: Hi, I have just discovered these old message on the SQLite Yahoo! Group: http://groups.yahoo.com/group/sqlite/message/2115 http://groups.yahoo.com/group/sqlite/message/2117 This does soun

[sqlite] Direct use of SQLite btree functions / performance

Hi, I have just discovered these old message on the SQLite Yahoo! Group: http://groups.yahoo.com/group/sqlite/message/2115 http://groups.yahoo.com/group/sqlite/message/2117 This does sound very interesting! If I simply want to store binary data that I want to access via an index number again