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:

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?

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?

10-22-2003, 09:58 AM	#1
jimigisme Green Mole Join Date: Sep 2003 Posts: 10	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.

10-24-2003, 05:07 PM	#2
Charter Head Mole 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.

11-07-2003, 02:32 PM	#4
Charter Head Mole 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.

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

10-30-2003, 09: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