Geographical indexing

[Thomas Flemming]

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.

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