PDA

View Full Version : Temporary Table


jimigisme
10-22-2003, 09:58 AM
I have several sites spidered and indexed, but for some reason the temporary table never seems to shrink. Should it be reducing in size? If so, how and when does it happen?

Here is what I have in my database:
Hosts : 13472 Entries
Pages : 56298 Entries
Index : 6809830 Entries
Keywords : 391177 Entries
Temporary table : 553219 Entries

Thank you.

Charter
10-24-2003, 05:07 PM
Hi. The temporary table should probably not be growing like that. The spider.php file has the following code:

// clean the tempspider table
$query = "DELETE FROM ".PHPDIG_DB_PREFIX."tempspider WHERE site_id=$site_id AND (error = 1 OR indexed = 1)";
mysql_query($query,$id_connect);

Can you post the first few entries from the table? What versions of PHP and PhpDig are you using?

jimigisme
10-30-2003, 09:15 AM
Sure thing Charter, and thank you for your time.

PHPDIG 1.6.2
PHP Version 4.3.3
Apache 2.0
W2k sp4
MySQL 4.0.16
File Id Level Path Site_ID Indexed Update Error
detail.asp?ProductId= 172174 4 <BLANK> 1744 0 10/3/2003 0
wish_list.asp 172175 4 /login.asp 1744 0 10/3/2003 1
accountinfo.asp 172176 4 /login.asp 1744 0 10/3/2003 1
<BLANK> 172177 0 Sbrown/ 1736 0 10/3/2003 0

Charter
11-07-2003, 02:32 PM
Hi. Do any of the values in the indexed column equal one? Also, how many entries do you happen to have in your excludes table?