Jay, thanks for your quick response :) All objects need to contain all fields, however not all will be filled. It may be the case that the user wants to UPDATE a field that was empty before, it´s not read-only.
btw, I´m using Sqlite 3.2 Thanks, André -----Original Message----- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: Monday, April 10, 2006 7:43 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to handle large amount of data? On 4/10/06, André Goliath <[EMAIL PROTECTED]> wrote: > HI List, > > I´m curently in the design phase of a rather large DB project > and would love to hear your qualified thoughts on this. > > You can think of the data to be stored as objects with some properties, an > unique ID and then 21 fields which will contain TEXT data, > > The DB acts as kind of archieve that allows the user to search in the > object´s text fields. > Each field will contain around 100 to 1.000 chars, and per object only 7-12 > fields will be used. Will all objects have all 21 fields, or will each object have a different set of fields?