Geographical indexing

[Ruslan Zasukhin]

On 4/19/09 9:11 PM, "Thomas Flemming" <tf at ttqv.com> wrote:

>>> Using API, cascading calls to FindRange() is slower.
>> 
>> I do not see why it can be slower.
>> It should be faster.
> 
> 
> resultSet = fldEN.FindRange(False, .SouthInt, 90 , False, resultSet)
> resultSet = fldES.FindRange(False, -90 , .NorthInt, False, resultSet)
> resultSet = fldEW.FindRange(False, -180 , .EastInt, False, resultSet)
> resultSet = fldEE.FindRange(False, .WestInt, 180 , False, resultSet)
> 
> This is 20% slower for me then one sqlselect.
> Buts its maybe a vb.net-thing.

Can be.

Will say thank you, if you put into Mantis
Simple project that reproduce this.
We will try to profile it to see where is bottleneck.



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]