Geographical indexing

[Thomas Flemming]

Hi,


did you have a look at this already?

In the meantime I found another issue.
There is a serious memoryleak somewhere in this FindRange-Function (VNET4.1)

You can use the same test-program for this.
Just put the TestFindRange() in a loop:

While True
      TestFindRange()
End While

and on my mashine after 5min all 2GB memory is done and windows is crashing.
I added this into manits.

Best regards,
Tom



Ivan Smahin schrieb:
> Hello Thomas,
> 
> Wednesday, April 22, 2009, 12:32:28 PM, you wrote:
> 
>> Hi Ruslan,
> 
>>> Hi Tom,
>>>
>>>> sorry for being unpatient ;-)
>>>> But befor I start evaluating other options, I would like to know, what is the
>>>> maximum speed I can expect from Valentina for this kind of select.
>>>>
>>>> I still hope, that there might be a bug...
>>> Not so fast please :)
>>> It was Easter here.
>> Sorry ... :-)
> 
>>> Ivan have ask question:
>>>
>>> * what time of queries is?
>>>     0.1 sec
>>>     1 sec
>>>     10 sec ?    
>>>
>>> * if queries itself are long, then SQL binding will not help a lots of
>>> course. It helps for very short fast queries when SQL parser overhead is
>>> significant.
>>>
>> Are you trying my sampleproject from mantis?
>> On my computer each of the three tests takes around 7 sec for 100 queries with
>> different parameters into this sample-database with 800000 records.
>> So less then 0.1 sec for one query.
> 
> There  is 2008 project attached. Could you please send me the same for
> 2005 (just no 2008 Microsoft Studio here)?
> 
> 
> 
> 
> 

-- 
/****************************************
**   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!
***************************************/