"Seach Ignore Words" valid for MySQL search engine?

[wintermute]

Hello everone,

Do the file "search_ignore_words.php" and it's contents are used if we use the MySQL engine as board search engine?

Also, is it normal that one a board with about 250000 posts, deleting native indexes and enabling MySQL search engine indexes ups the database size about 150MB? I was expecting MySQL Fulltext engine to use little space for indexes?

With no indexes, database is about 170 MB
After creating index for MySQL Native, database is about 330 MB

Many thanks,

[Nicholas the Italian]

With no indexes, database is about 170 MB
After creating index for MySQL Native, database is about 330 MB

Not really surprising, as practically all words in posts need to be duplicated in other tables and accociated with the post they're in.
Fulltext-mysql should take less space than fulltext-native, but you can't reduce such informations to take less space than what they phisically are. Not sure whether MySQL uses some kind of compression.

[code reader]

Do the file "search_ignore_words.php" and it's contents are used if we use the MySQL engine as board search engine?

this file is not used with fulltext_mysql.
it isn't used with fulltext_native, either.
imo, it should have been removed from the code, together with some more deadwood, eg., the "synonym" thingy.

Also, is it normal that one a board with about 250000 posts, deleting native indexes and enabling MySQL search engine indexes ups the database size about 150MB? I was expecting MySQL Fulltext engine to use little space for indexes?

With no indexes, database is about 170 MB
After creating index for MySQL Native, database is about 330 MB

it is unfortunate that phpbb's implementation of the fulltext_mysql uses twice as much index space as it really should.
(read viewtopic.php?p=187578#p187578 )
i can post a "mod" that fixes this, but i don't want to wrap it as a real mod, when i believe it's a bug and should be fixed in the core code.
unfortunately, the developer (naderman) doesn't seem to share my view...

[spacemarc]

this file is not used with fulltext_mysql.
it isn't used with fulltext_native, either.
imo, it should have been removed from the code, together with some more deadwood, eg., the "synonym" thingy.

i'm using a search_ignore_words.php with a lot of words.
If this file isn't used, in that way discards phpBB3 the common words before inserting the post in the db?