[WP3] Re: Another Associate question.

[Kor G. Begeman]

Jan,

you could try something like this, as AWOPER, in sqlplus:


create index index_htm_16_25 on "SourceList*sources" (TRUNC("HTM"/262144));

After this you should try to make an AssociateList with a 
search_distance of 2 arcsec.

Kor.

Jan Snigula wrote:
> Hello Kor,
> 
> I was using a search distance of 2 (arcsec?) for the test.
> 
> Jan
> 
> On Fri, 30 Jan 2004, Kor G. Begeman wrote:
> 
> 
>>Jan,
>>
>>I discovered the same problem and could speed things up a lot by making
>>an index on TRUNC(HTM/?) where HTM is the column in the
>>SourceList*sources table. If you will provide me the search distance
>>than I will give you the SQL statement to make this index. This is part
>>of the tuning we still have to do.
>>
>>Have a nice weekend,
>>
>>Kor.
>>
>>
>>Jan Snigula wrote:
>>
>>>Hello, Kor, Danny
>>>
>>>I now got the SourceList generation done (thanks for the help), and tried
>>>to associate two of them. Both lists have about 7 to 8 thousand objects.
>>>After several hours in AL.make() finally the computer with the database on
>>>it came to a halt, with the 1GB RAM used up presumably by the
>>>association.
>>>
>>>Is this a known performance problem, or did I simply do something wrong?
>>>In principle I followed the procedure from the manual.
>>>
>>>Jan
>>
>>--
>>
>>Dr. K.G. Begeman
>>OmegaCEN
>>Kapteyn Institute
>>University of Groningen
>>Postbus 800                         NL-9700 AV Groningen
>>Landleven 12                        NL-9747 AD Groningen
>>The Netherlands
>>Telephone                           +31-(0)50-3634059/4073
>>Telefax                             +31-(0)50-3636100
>>e-Mail                              kgb at astro.rug.nl
>>WWW                                 http://www.astro.rug.nl/~kgb
>>

-- 

Dr. K.G. Begeman
OmegaCEN
Kapteyn Institute
University of Groningen
Postbus 800                         NL-9700 AV Groningen
Landleven 12                        NL-9747 AD Groningen
The Netherlands
Telephone                           +31-(0)50-3634059/4073
Telefax                             +31-(0)50-3636100
e-Mail                              kgb at astro.rug.nl
WWW                                 http://www.astro.rug.nl/~kgb