Subject | Re: Geographic data |
---|---|
Author | danielberstein |
Post date | 2002-10-03T21:32:57Z |
Hmmm...
<ME THINKING TWICE>
Ok, I could use a generator and simply read it's current value.
</THINKING>
Sometimes the best answer is another question. Thanks Sean!
Do you have any clue about my other question? The fact is that we use
a product called "Autodesk Mapguide" that generates vectorial maps.
Some information layers may be retrived from database. The map server
queries the database with something like:
SELECT <some col>
FROM <some table>
WHERE <lat col> BETWEEN <lat min> AND <lat max>
AND <lon col> BETWEEN <lon min> AND <lon max>
We use Oracle as our RDBMS, but I would like to use FB as a
development platform (Oracle may be expensive to license and
administer, but it *is* the best performing DBMS I've ever used). I
was wondering how the index compresion could negativly affect the
above query. Any pointers would be welcome.
<ME THINKING TWICE>
Ok, I could use a generator and simply read it's current value.
</THINKING>
Sometimes the best answer is another question. Thanks Sean!
Do you have any clue about my other question? The fact is that we use
a product called "Autodesk Mapguide" that generates vectorial maps.
Some information layers may be retrived from database. The map server
queries the database with something like:
SELECT <some col>
FROM <some table>
WHERE <lat col> BETWEEN <lat min> AND <lat max>
AND <lon col> BETWEEN <lon min> AND <lon max>
We use Oracle as our RDBMS, but I would like to use FB as a
development platform (Oracle may be expensive to license and
administer, but it *is* the best performing DBMS I've ever used). I
was wondering how the index compresion could negativly affect the
above query. Any pointers would be welcome.
--- In ib-support@y..., "Leyne, Sean" <sleyne@a...> wrote:
> Daniel,
>
> What do you want the "MAX(<column>)" for?
>
>
> Sean