Re: EDS database speed questions
- Posted by AlanO Aug 24, 2008
- 1198 views
The app was punted as not needing any external app/dll.. would hate to have to tell the client that its no longer the case...SQL or otherwise.
How about if I created my own index of every say 100th record, in a (memory) sequence. Do a binary search against that, then use the results as the hi/lo starting points in the big database? Disk access is always slower than memory. Another way of thinking would be to take advantage of the 512 byte physical disk sector, where I would assume that when fetching a record, the nearby records would also be in memory and so would not incur a speed hit. Design the search accordingly.
Loading the database is also not a "one-off". The data changes as a result of both my app and external issues, and so will be reloaded once a day, so I'd like to keep the load time down too.
Regards Alan
