View Single Post
Old 08-18-2004, 11:21 AM   #4
rispbiz
Green Mole
 
rispbiz's Avatar
 
Join Date: Jan 2004
Posts: 15
Addition to build.searchimages.pl

Here is another addition I had to add to the build.searchimages.pl

Here is the orginal part of the build.searchimages.pl

$req_url $basepath/$outfile";
system(`$sysstring`);
$sysstring = "/usr/local/bin/scp $basepath/$outfile search_server:/your_path/thumbnails";
print "SCP: $sysstring\n";
system("$sysstring");
$db->do("DELETE FROM request_thumb WHERE url = '$curarray[0]'");
--- end build.searchimages.pl

Here I had to add a OPTIMIZE TABLE after the delete to prevent overhead in the table.

$req_url $basepath/$outfile";
system(`$sysstring`);
$sysstring = "/usr/local/bin/scp $basepath/$outfile search_server:/your_path/thumbnails";
print "SCP: $sysstring\n";
system("$sysstring");
$db->do("DELETE FROM request_thumb WHERE url = '$curarray[0]'");
$db->do("OPTIMIZE TABLE request_thumb");

--- end build.searchimages.pl
rispbiz is offline   Reply With Quote