Sep 27, 2009, 5:21 PM
Post #1 of 2
Perl Script to search the database
Here is my problem statement: I have 2 database tables. I need to fetch an element(for eg: domain) from table 1, compare it with all the values of the similar column in table 2, and if the domain is not present, update table 2 with the domain.
I have to scan last 3 months of entries for this. Table 2 should update only if domain is not present for the last 3 months. But it should get updated if the domain was present before 3 months.
Is there any efficient technique to do this? Any modules that I could take help of to make it more efficient?