André Goliath wrote:
Denis,
I didn´t knew references where possible in Sqlite 3.2,
thanks for pointing that out!
The reference keyword in the column declaration doesn't really do
anything in SQLite. I use it more as a comment for human readers so they
know which column to use when joining tables.
Do you have more specific information on how that is implemented in SQLite?
Would you think the amount of memory needed would be acceptable for an
field_data with
1.000.000 objects * 21 fields * 1.000 chars ?
It is quite unlikely to reach that DB size,
but I have to expect the unexpected ;)
Well, that would be a large table, about 21 GB plus overhead, say 25-30
GB. But if that's the amount of data you have to store, you will have to
store it somewhere. It doesn't take anymore more space to store the data
in a normalized table.
As Jay said, the table is never loaded into memory, so memory should not
be an issue.
HTH
Dennis Cote
