|
10-22-2003, 09:58 AM | #1 |
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 |
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:
__________________
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. |
10-30-2003, 09:15 AM | #3 |
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 |
11-07-2003, 02:32 PM | #4 |
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 |