performance problem

Ruud,

thanx for your reply.

I am narrowing down on the problem...found that Suse 9.2 has a lot of
memory related problems.

reverted back to 9.1 and rebuilding the app..will post an update.

you suggestion will not work for me though...i need to check existing
records and create new records..which cannot be done on one table.
unless you are going thru hoops and doing a lot of text processing....at
which point why do you need a database :-)

also here is something interesting that i found regarding IN vs = on a
btree index.

select col1, col2
from table1
where col1 in ( 1,2,3)
;

this comes right back

select col1, col2
from table2
where col1 = 1
;

comes right back.

select col1,col2
from table2
where col1
IN
(
 select col1 from table2
where col1 between 1 and 2
)
;

this takes a while....

which tells me IN is still not optimized..or am i missing something?

lastly..please post to the forum and not directly to my email....so the
community can see the 'whole' picture.

thanx
Sanjay