fulltext natvie Vs. fulltext mysql

Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Post Reply
user99
Registered User
Posts: 63
Joined: Thu Jan 04, 2007 9:36 pm

fulltext natvie Vs. fulltext mysql

Post by user99 »

So what does it mean in practice?

If set to "fulltext mysql", is it possible to search for phrase?

BondGamer
Registered User
Posts: 113
Joined: Mon Dec 15, 2003 8:20 pm
Contact:

Re: fulltext natvie Vs. fulltext mysql

Post by BondGamer »

MySQL has a built in fulltext interface in the database, while other databases do not. Supposedly it is better to use MySQL Fulltext if you can.

bigon_be
Registered User
Posts: 6
Joined: Sun Dec 31, 2006 2:06 pm

Re: fulltext natvie Vs. fulltext mysql

Post by bigon_be »

Good question what is the best choice? What are the pros and the cons?

User avatar
jojobarjo32
Registered User
Posts: 164
Joined: Wed Jun 22, 2005 7:38 pm
Location: France

Re: fulltext natvie Vs. fulltext mysql

Post by jojobarjo32 »

BondGamer wrote: while other databases do not

Wrong... MySql is not the only SGBD which supports fulltext indexing. It's phpBB 3.0 which only supports MySql fulltext but it will be possible for mods authors to write a new search backend to support others SGBD.
bigon_be wrote: Good question what is the best choice? What are the pros and the cons?

I don't know very well the pros and cons but IIRC, fulltext_mysql is a better choice (in terms of speed) for the "small" forums. For the big ones (more than 1 million posts?), I believe fulltext_native is better...
If you choose fulltext_mysql, the setting which allow to not index some forums is not effective, nor the minimum and maximum characters limit.

Post Reply