Would a fulltext index across multiple columns be better in this case?
Currently, the search query that I’m using for searching my forum looks like this (this particular search was for the term “6.18”) (this is just part of the where clause that deals with searching:
FULLTEXT searching for spaces, full stops
I am experimenting with FULLTEXT searching, using the InnoDB storage engine. I am upgrading from MYISAM to InnoDB and I have noticed that a lot of queries containing LIKE clauses, which were fast with MYISAM, are much slower using InnoDB. Removing the LIKE clause and replacing it with FULLTEXT searching is lightning fast in InnoDB, but seems to come with a couple of gotchas which I hadn’t thought about.
FULLTEXT searching for spaces, full stops
I am experimenting with FULLTEXT searching, using the InnoDB storage engine. I am upgrading from MYISAM to InnoDB and I have noticed that a lot of queries containing LIKE clauses, which were fast with MYISAM, are much slower using InnoDB. Removing the LIKE clause and replacing it with FULLTEXT searching is lightning fast in InnoDB, but seems to come with a couple of gotchas which I hadn’t thought about.
FULLTEXT searching for spaces, full stops
I am experimenting with FULLTEXT searching, using the InnoDB storage engine. I am upgrading from MYISAM to InnoDB and I have noticed that a lot of queries containing LIKE clauses, which were fast with MYISAM, are much slower using InnoDB. Removing the LIKE clause and replacing it with FULLTEXT searching is lightning fast in InnoDB, but seems to come with a couple of gotchas which I hadn’t thought about.
FULLTEXT searching for spaces, full stops
I am experimenting with FULLTEXT searching, using the InnoDB storage engine. I am upgrading from MYISAM to InnoDB and I have noticed that a lot of queries containing LIKE clauses, which were fast with MYISAM, are much slower using InnoDB. Removing the LIKE clause and replacing it with FULLTEXT searching is lightning fast in InnoDB, but seems to come with a couple of gotchas which I hadn’t thought about.
FULLTEXT searching for spaces, full stops
I am experimenting with FULLTEXT searching, using the InnoDB storage engine. I am upgrading from MYISAM to InnoDB and I have noticed that a lot of queries containing LIKE clauses, which were fast with MYISAM, are much slower using InnoDB. Removing the LIKE clause and replacing it with FULLTEXT searching is lightning fast in InnoDB, but seems to come with a couple of gotchas which I hadn’t thought about.