Re: EDS database speed questions
- Posted by ChrisB (moderator) Aug 24, 2008
- 1192 views
Hi
Of course you have your own programming issues, but I would still say with a database that size, adding sqlite as a dll adds only about 1/2 a megabyte to to the program size (as a dll), results in a much more secure database with rollback features in the event of a crash, allows use of industry standard sql statements, allows exceptionally quick maitainance and updates, uses b-tree searches so is lightning fast, and uses an engine embedded in devices used everday (your phone, for instance)
As far as trumping no use of external programs, were you expecting 2.2 million records at the first program consultation. Wouldn't the client rather have transparent speed and reliability issues at the expense of a zero set tiny dll, installed into the programs directory?
I dunno, can you tell I'm an sqlite fan?
I don't know your database structure, but using every 100th record sounds like an additional overhead, and may be heading towards a hash table type of thing.
Chris
