@robinhouston I guess building a new table and using joins might be most efficient, but isn’t practical when handling many texts

@robinhouston I see your point, but I’m not sure one can actually build queries that big

Depends on infrastructure. Generally, get front-end taking load cos it can be scaled more easily than back-end. /via @dicepeople

@dicepeople thanks!

@themba thanks for passing on my question!

@Inventrix I suspect it’s better not to keep hitting the database, but let’s see what the experts say!

@robinhouston that would be a VERY long query! (the queries relate to words in a text, the MySQL having values for each word)

@Inventrix thanks for spreading the net!

Also, is it possible to ascertain the threshold where one becomes better than the other?

Ie is it better to make PHP process loads of conditionals rather than run loads of database queries?