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
|