Re: [sqlite] More columns vs. several tables

2006-05-04 Thread drh
Felix Schwarz <[EMAIL PROTECTED]> wrote: > > If I don't build the two tables in the > > INSERT INTO entries .. > INSERT INTO entries .. > INSERT INTO entries .. > > INSERT INTO binaries .. > INSERT INTO binaries .. > INSERT INTO binaries .. > > but instead do

Re: [sqlite] More columns vs. several tables

2006-05-04 Thread Felix Schwarz
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( entry_id I

Re: [sqlite] More columns vs. several tables

2006-05-02 Thread John Stanton
If you have a wide table and want to optimize performance you would do better to increase the page size. JS Jay Sprenkle wrote: On 5/2/06, Felix Schwarz <[EMAIL PROTECTED]> wrote: Hi, Morning! "Put small and frequently used columns early in the table to minimize the need to follow the o

Re: [sqlite] More columns vs. several tables

2006-05-02 Thread drh
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( > entry_id INTEGER PRIMARY KEY, > som

Re: [sqlite] More columns vs. several tables

2006-05-02 Thread Dennis Cote
Felix Schwarz wrote: 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 t

Re: [sqlite] More columns vs. several tables

2006-05-02 Thread Jay Sprenkle
On 5/2/06, Felix Schwarz <[EMAIL PROTECTED]> wrote: Hi, Morning! "Put small and frequently used columns early in the table to minimize the need to follow the overflow chain." Now, that's interesting! And I'm wondering whether there is a big performance hit for a simple SELECT binar

[sqlite] More columns vs. several tables

2006-05-02 Thread Felix Schwarz
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