The following query takes approx. 3-5+ minutes
to complete. I would like to get this down to around
2-3 seconds. Other RDBMS complete it in 1 second.
I am running 8.0.1 on XP P4 2.6 1GB for dev work.
select i.internalid, c.code
from local.internal i
inner join country.ip c on
(i.ip between
optimizations to
the postgres query builder that got backed out in 0.92, due to a
possible really bad failure mode. Thankfully, because all of this is
machine generated SQL we can just improve the generator, rather than
having to retool the entire application.
--
jesse reed vincent -- [EMAIL PROTECTED