Geographical indexing
Thomas Flemming
tf at ttqv.com
Mon Apr 20 04:50:16 CDT 2009
Hi,
>>>> 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.
>
I put a test-project into Mantis.
Regards
Tom
--
/****************************************
** Dipl.-Ing. Thomas Flemming
** Software Development
**
** Touratech AG
** Auf dem Zimmermann 7-9
** D-78078 Niedereschach
**
** mail tf at ttqv.com
** fon +49 (0) 7728 9279-206
** fax +49 (0) 7728 9279-29
**
** http://www.ttqv.com
** http://www.touratech.de
**
** ... und immer dem Pfeil nach!
***************************************/
More information about the Valentina
mailing list