When the same solution is offered in rapid intervals, it must be the
correct one then! :)
To elaborate on what Chris mentioned regarding relational database
methodology and related tables, here is why and a good description of
how to do that correctly:
https://en.wikipedia.org/wiki/First_normal_form
And to add to the slew of "Few-tables-many-rows rather than
Many-tables-few-rows" solutions offered, one thing to note: After a
single table contains a few million rows, INSERTing will become slightly
slower, but the difference will still be measured in milliseconds rather
than seconds. This really is by far the fastest (and correctest) way.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
