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 c.st
my choice ;-) ]
Can you try using SearchBuilder 0.90? That made certain 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
