Re: EDS database speed questions
- Posted by AlanO Aug 24, 2008
- 1195 views
Thanks Derek! Using your 45 max (I'll assume 43 average) my app will have 10750 disk accesses average, each time the user hits go. If the disk runs at 20 milliseconds, thats 215 seconds of wait just for disk access! Hmmm... poke the index into memory and get assembly to do a binary search of the index. The memory needed is 19.8Mb so thats do-able and nothing could be quicker. Should result in about 250 disk accesses at 20 milliseconds, thats 5 seconds.
Is there a quicker method? Chris I'll still get around to learning SQL, but I doubt if that would be quicker than the memory/assembly method would it?
Derek, could there be a memory/read only/performance option for eds database indexes in the future?
Thanks guys Alan
