Page 2 of 2
Posted: Tue Feb 22, 2005 8:15 pm
by ray.wurlod
If Ascential wrote this, they almost certainly regard it as their intellectual property. You may have to ask them to provide it, rather than Gazelle, who would be bound by a licensing agreement not to reveal details.
Re: Range Lookup
Posted: Wed Oct 17, 2007 11:17 am
by ejugos
I'm having the same performance issue, any help on this?.
EJS.
varshanswamy wrote:I have 2 database stages
First database stage contains a number field called IP_NUMBER.
Second database stage contains fields called
IP_FROM
IP_TO
COUNTRY_NAME
COUNTRY_CODE
DOMAIN_NAME
I have done a sparse lookup and a query in the database as follows
that is to obtain COUNTRY_CDOE, COUNTRY_NAME, DOMAIN_NAME based on the IP_NUMBER.
SELECT
COUNTRY_CODE,
COUNTRY_NAME,
DOMAIN_NAME
FROM
IP_LOOKUP
WHERE
ORCHESTRATE.IP_NUMBER
BETWEEN
IP_FROM
AND
IP_TO
The problem is since it is a sparse lookup, it is taking a very long time. Even though the table has been indexed, it is executing at the rate of one record per second, there are 1 million records, to be processed, so it is really very slow. Please suggest on this.