First of all, thank for u support! Really !
> The most efficient way would be to arrange to have the Oracle database
> engine do most of the comparisons. I am not enough of a database expert to
> recommend ways to do this.
I agree with u , but it's something that is not possible without a
dblink, that's why I'm here to write some code.... :)
> The fastest way to do this in Perl would be to save the results of one query
> in memory in a data structure of some type, either an array or a hash. Then,
> as the results from the second query are fetched, compare against the copy
> in memory and save what differs (you have not explained how to decide when
> the two results differ).
That's exactly what I was trying to do,and u are right probably I was
not so clear about "how to decide when the two results differ".
Let's try to put some light on:
The results of the first query will be an array something like this:
@G1 = (["alfa" , "10"] ,
["beta" , "11"]);
Similar the second query will give this kind of array:
@L1 = (["alfa" , "10"],
["gamma" , "12"]);
And finally the third query:
@G2 = ("gamma");
G1 and G2 are two query on the same db and same schema too.
L1 is on another db server and of course on a different schema.
So what I need is to discharge the results that I found in all the three
queries and take only what differ.
For something coming directly from the data nature I need to check
before the G1 and L1 and then check what differ on G2.
In example the results that i need is the couple "beta 11".
>
> How huge? Some representative numbers would help.
>
The results of the query of G1 is on the order of 100k+ records, and the
machine that will do the perl code is a linux dell with 3GB of memory
and a cpu AMD Opteron 1.7GHz,..
> I do not understand what you are saying. Are you saying that queries G1 and
> L1 are huge and G2 is not?
No I was just trying to say that i had problem to check difference
against the G2 query couse it just have one column of results (normal
array) where the results coming from the other two query are a 2 column
(multidimensional array).
>> We were all newbies at one time.
Hope to grow up then :)
Again tnx all for u help!
--
Vito Pascali
ICT Security Manager
IT Senior System Administrator
[email protected]
