Geographical indexing

[Ruslan Zasukhin]

On 4/27/09 7:13 PM, "Ivan Smahin" <ivan_smahin at paradigmasoft.com> wrote:

Hi Thomas,

> So you may see that pooled (binded) query runs faster then query which
> is parsed each time.
> 
> Another  conclusion  is: FindRange takes almost all the time anyway
> (Internally that sql-conditions produce similar to yours FindRange calls). So
> in  this  particular  case  there is no much difference between that 3
> ways.

So it seems you have now best speed from Valentina.

>From Ivan tests we have 0.005 sec on single FindRange search for
your 800K table.

You think this is slow?


Improvement can be possible (in theory) only from data structures changes.



-- 
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]