PhpDig.net

Go Back   PhpDig.net > PhpDig Forums > Troubleshooting

Reply
 
Thread Tools
Old 10-22-2003, 08:58 AM   #1
jimigisme
Green Mole
 
Join Date: Sep 2003
Posts: 10
Question Temporary Table

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.
jimigisme is offline   Reply With Quote
Old 10-24-2003, 04:07 PM   #2
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
Hi. The temporary table should probably not be growing like that. The spider.php file has the following code:
PHP 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?
__________________
Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.
Charter is offline   Reply With Quote
Old 10-30-2003, 08:15 AM   #3
jimigisme
Green Mole
 
Join Date: Sep 2003
Posts: 10
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
jimigisme is offline   Reply With Quote
Old 11-07-2003, 01:32 PM   #4
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
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?
__________________
Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.
Charter is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
No link in temporary table raphael_ita Troubleshooting 4 12-07-2004 12:25 AM
clearing out the temporary table liquidice How-to Forum 0 08-30-2004 04:14 PM
Help Please: No link in temporary table SystemX Troubleshooting 5 06-27-2004 10:20 PM
No link in temporary table Steve Joynt Troubleshooting 1 06-10-2004 01:05 AM
No link in temporary table gooseman How-to Forum 4 05-14-2004 02:24 AM


All times are GMT -8. The time now is 11:03 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.