I have tried different things, but these "popen or plocate" equivalents, seem very
complicated and tricky. And how this is going to behave on different user machines remains to be seen.
In the mean time I picked up some tips and tricks on how to speed up SQLite insert speed using PRAGMA settings
and batch inserts. 53.000 indexed records does not take forever, but 10 minutes tops. = 300.000/hour.
I guess I'll live with that.
thx,
Paul
Edit: there is one strange parameter:
" 'PRAGMA synchronous = 0' "
If you switch it off, insert of 53.000 records is almost instantaneous, like a .txt file.
The caveat is, that any problem with the program, the os, the environment, whist running,
can cause database corruption. Not a good idea ... except...
If it takes only a few seconds for zillions of records, I can create a new database every time.
And if it gets corrupted, no problem, we'll do it again.
Time is money, even when dealing with prayer cards.
Paul
complicated and tricky. And how this is going to behave on different user machines remains to be seen.
In the mean time I picked up some tips and tricks on how to speed up SQLite insert speed using PRAGMA settings
and batch inserts. 53.000 indexed records does not take forever, but 10 minutes tops. = 300.000/hour.
I guess I'll live with that.
thx,
Paul
Edit: there is one strange parameter:
" 'PRAGMA synchronous = 0' "
If you switch it off, insert of 53.000 records is almost instantaneous, like a .txt file.
The caveat is, that any problem with the program, the os, the environment, whist running,
can cause database corruption. Not a good idea ... except...
If it takes only a few seconds for zillions of records, I can create a new database every time.
And if it gets corrupted, no problem, we'll do it again.
Time is money, even when dealing with prayer cards.
Paul
It is more important to do the right thing, than to do the thing right.(P.Drucker)
Better is the enemy of good. (Montesquieu) = French version for 'kiss'.
Better is the enemy of good. (Montesquieu) = French version for 'kiss'.