I've just started a rebuild of my searchtables.
My board (www.foilzone.com/phpbb2
) has these statistics before rebuilding the search tables:
Number of posts: 13811 Posts per day: 12.54
Number of topics: 2771 Topics per day: 2.52
Number of users: 801 Users per day: 0.73
Board started: Wed Nov 06, 2002 12:00 am Avatar directory size: 749.92 KB
Database size: 22.74 MB Gzip compression: OFF
Now, after a while of rebuilding search tables, using various settings for timeouts, amount of posts per session etc, it keeps time-outing.
If i set the post counter to 1 per session, and a time out of 60 seconds it keeps running more or less. Only does 1 post per go.
Think i've found a bug too by the way... The report on screen mentions "processing next 10 posts" which is the amount i've selected for the previous session, which timed out. It apparently displays the values for the previous session...
Nevertheless. My database reports 13811 posts. On average, how big would the search-tables grow into then?
Now the MOD reports an expected database size of 8 GB!!!!!!! If that's correct my server will explode!!!!
The report screen:
Rebuild Search Progress
Processed post ids : 6729 - 6729
Timer expired at 61 secs. Processing next 10 post(s). Please wait...
Processing post details
Processed Posts Percent
Current Session from 9 to 9 (out of total 8541) 0.11 % completed
Total from 5280 to 5280 (out of total 13812) 38.23 % completed
Processing time details
Last 1 post(s) of current session 00 days, 00 hours, 01 minutes, 01 seconds
From the beginning of current session 00 days, 00 hours, 05 minutes, 52 seconds
Average per cycle of current session 00 days, 00 hours, 00 minutes, 59 seconds
Estimated until finish of current session 03 days, 20 hours, 41 minutes, 36 seconds
Database size details
Current Estimated after finish
Search Tables size 870.28 MB 8873.20 MB
Database size 892.52 MB 8895.44 MB
Starting post_id 6720
Processed post(s) on last cycle 1
Time limit 60
Board status Enabled
(*) All the estimated values are calculated approximately
based on the current completed percent and may not represent the actual final values. As the completed percent increases the estimated values will come closer to the actual ones.
Is this in any way normal????? I must delete quite some search words then, in order to keep database size down in an acceptible way...
Acceptible would be around 1 gb maximum, but EIGHT is too much.
I see people with larger amounts of posts, but with smaller databases.
I read some little remark in the MOD's docs about search_stopwords.txt but i can't seem to find this very file. I assume it must be found somewhere in the Phpbb2 folder or subfolders.
How does this work, what can i do to decrease database size?
Any help would be greatly appreciated!! My board soon offers searchability, but no longer usabilty cuz the db is bigger then my hosting account.
Thanks in advance all!!