Modifying the database?

Hello all,

I have about 3,000 URLs that are already in the database that I need to do a 
reindex on. The entire database now consists of over 4 million URLs. I ONLY 
want to reindex these 3,000 URLs and I have to reindex them once a week. 
These 3,000 URLs are on many different servers and this 3,000 could easily 
grow to a much larger number. Here's my question:

I was wondering if I were to write a Perl script that would open the 
database table urlword and for each of these URLs that I need to update, I 
would change the the following:

next_index_time = 0
last_modified = ''
last_index_time = 0

The mysql command would be:

update urlword set next_index_time = 0, last_modified = '', last_index_time 
= 0 where url = 'http://www.somepage.com/';

Will this work? Will it break anything? Then I would make a modification to 
the aspseek.conf file like this:

Period 10y

That will restrict the reindexing to only documents that are at least 10 
years old which means all those URLs that I modified to be reindexed without 
fear that any of the other 4 million URLs will be touched. This will let me 
reindex all these URLs weekly.

The reason I ask this is that people are telling me they will pay me to 
update their URL in the database once a week for a modest fee. I will be 
happy to develop this simple Perl script and make it available to other 
aspseek users. I am very knowledgeable with Perl, mysql and DBI and would 
like to develop many other applications to enhance administration and 
provide capabilities that are much needed.

Hope someone in this list can answer my question.

Thanks,
Karen




_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963