May 20, 2015 in Technical Problems
I use Innodb for my Database cause i get a lot more performance with it.But with the new table core_search_index that IPS4 uses for the Search Engine, im in doubt whether i choose MyISAM or Innodb.
A search only requires read statments, and i think MyISAM is stronger than Innodb in that department... But what happens if many people makes posts at the same time? Will the board writes all of them immediately to the index table and it could cause Table Locks? Or it will only write to the posts tables, and later will write to the index table using the background process's?
Have you thought about using sphinx? It's so much easier to setup in IPB4. You don't have to run the 15 minute cron tasks anymore and it removes all the the content in the core_search_index which halves the size of the DB almost.
I use Sphinx with IPB 3.4, and there is a huge difference to mysql search. But i tested in IPS4 both and i don't see any difference in terms of results and speed. So i don't think i will gain anything having one more service running in the background.
This topic is now archived and is closed to further replies.
Started 11 hours ago
Started 2 hours ago
Started 13 minutes ago