Geographical indexing

[Thomas Flemming]

> 
>> I tested binding, but it does not give a speed improvement.
> 
> Strange.
> 
>> But I only tested for a single Select, no Union.
> 
> Never mind
> 
> Well, I remember that not all queries are and can be cached
> But your kind of SELECT should be.

But what should be cached? Where should the speed-improvement come from?

I mean, I never have the same select again.
The parameters for the Where-statement are always different.

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