Hi,
I built a view of 50k records that I need to access. With normal view it is too slow (180 ms), so I
try with hash view that I never used, and the result is even slower !(250 ms) !
(I've just read the new page http://www.equi4.com/mkmapping.html)
Here is what I've done :
c4_View
Riccardo Cohen wrote:
I built a view of 50k records that I need to access. With normal view
it is too slow (180 ms), so I try with hash view that I never used,
and the result is even slower !(250 ms) !
(I've just read the new page http://www.equi4.com/mkmapping.html)
Here is what I've done :
Thanks for your quick answer.
I did try to use only viewhash, for adding. But it did not change.
Here is a sample code you can run (attached)
200ms=time spent on 1 Select() !
I use a pentium 500Mhz
There must be something I dont understand...
Jean-Claude Wippler wrote:
Riccardo Cohen wrote:
I
Riccardo Cohen wrote:
Thanks for your quick answer.
I did try to use only viewhash, for adding. But it did not change.
Weird... try using Find() instead of Select()?
-jcw
___
metakit mailing list - [EMAIL PROTECTED]
Riccardo Cohen wrote:
It worked fine with Find() ;)
Then it comes two questions :
1) Is it normal that select does not use hash ?
2) If I do a SelectRange(), will it use hash ?
It seems you've just answered your own Q's. Think about it: hashing is
by value, not sorted. So select, which uses
