Database sizes

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
daniel
Registered User
Posts: 31
Joined: Tue Oct 02, 2001 4:44 pm
Contact:

Post by daniel » Wed Jan 16, 2002 10:25 pm

so you mean the search tables will be useless for hebrew ? :(

oh well saves up DB space :) (but i got 75megs on my host ... so... :) )

-daniel

kelani
Registered User
Posts: 26
Joined: Sun Jan 06, 2002 8:48 pm
Contact:

Post by kelani » Sat Jan 19, 2002 8:08 am

Posts: 13615
Topics: 976
Users: 102 (yah, they are Bored)

The search table concerns me. My upgrade always died on it, and I have 95,000 words in it. What options will be available to clear/compact/refresh this table? (especially if lots of posts have been deleted and the words are now invalid)
LOBD 10: Frightening over 29 million people since 1993 - http://www.lobd.org
Sexy Interaction: Not your normal board http://www.lobd.org/si/

MagiCat
Registered User
Posts: 131
Joined: Sat Dec 08, 2001 5:51 pm
Location: Sherman Oaks, CA
Contact:

Post by MagiCat » Sat Jan 19, 2002 8:31 am

Kindof off topic but it seems like a question that people are wondering. Is there a way to just eliminate the searching of bodies and maybe just have it only search subjects (A configuration option maybe?)

Maybe this should go on hacks.phpbb.com but I'm too lazy to go over there right now :)

User avatar
mk_jnr
Registered User
Posts: 170
Joined: Sat Sep 29, 2001 7:16 pm
Location: United Kingdom
Contact:

Post by mk_jnr » Tue Jan 22, 2002 6:08 pm

Number of posts: 620
Number of topics: 78
Number of users: 23
Database size: 465.18 KB :D
mk_jnr
PHP Newbie:)
Image

User avatar
mk_jnr
Registered User
Posts: 170
Joined: Sat Sep 29, 2001 7:16 pm
Location: United Kingdom
Contact:

Post by mk_jnr » Sat Jan 26, 2002 1:48 am

Number of posts: 1591
Number of topics: 156
Number of users: 37
Database size: 973.35 KB

More than doubles d/b size!!
mk_jnr
PHP Newbie:)
Image

josh
I am too lazy to register

Post by josh » Sat Jan 26, 2002 2:30 am

I feel as though their is something wrong with my setup then:

Users: 1476
Posts: 123,170
Size: 306.5 MB

:(

dougk_ff7
Former Team Member
Posts: 1191
Joined: Fri Jul 06, 2001 3:17 am
Location: I dunno, I've lost it.
Contact:

Post by dougk_ff7 » Sat Jan 26, 2002 3:55 am

daniel wrote: so you mean the search tables will be useless for hebrew ? :(

oh well saves up DB space :) (but i got 75megs on my host ... so... :) )

-daniel

Nope, you can define your own stopword and synonym list for any language... I'm not sure of the specifics, ubt I'm sure it can be done, to maximize performance.
dougk_ff7.... stand by for sig! oooh! wow.

User avatar
Faejon
Registered User
Posts: 22
Joined: Thu Aug 16, 2001 12:57 am
Location: Portland, Oregon USA
Contact:

Post by Faejon » Sat Jan 26, 2002 4:09 am

I just converted my phpbb 1.4.4 board to phpBB 2.0 CVS. Here are the stats -

Image
Faejon Dorunrun
Captain / Webmaster
Battle Cry of Terris-Thule

an Everquest guild

Locked

Return to “2.0.x Support Forum”