Geographical indexing

[Ivan Smahin]

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)?





-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com