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