Roger Binns wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Stef Mientki wrote:
Uptill now the dbase is small so no performance problems yet.
Wait until you have performance problems and then solve them :-) It is
almost always the case that performance issues don't crop up where you
think they will.
Yes, that might be the right approach ...
... but if I read somewhere that you can't delete columns ... ????????????
... I want to take some pre-cautions.
I think I'm getting more insight by now.
I'm using a Delphi wrapper SQLiteTable3 from Tim Anderson,
which always grabs all data of a query in a table,
so also all pictures from blobfields, while I only need the first 2 bytes,
so I'll modify that.
I can think of several solutions, but as my experience with databases is
almost zero, I can't decide
One nice feature SQLite has is virtual tables. You don't need to do
anything now, but if you have performance issues in the future, you can
use a virtual table for your data and behind the scenes do whatever you
want including storing the data as files.
Thanks Roger,
I didn't know that.
cheers,
Stef Mientki
