Use the custom (id, topic_id, posted) index on fluxbb_posts to speed up
searches that return a lot of results. I also added the posted field to
the predefined posts_multi_idx index so the "show_user_posts" action is
fast too.

On a related note, a key component of fast searching was to reorder the
fluxbb_search_matches table by the word_id column. This table has a lot
of rows (~73 million) and we want to be able to filter based on word_id
and quickly get the respective post ids. Previously it had to seek over
a couple of GBs to fetch the post ids. Ordering by word_id allows us to
get a (word_id, post_id) index for free (would take ~2GB to create it).

Support PHP 8.0

See merge request !3

Update local dev setup

See merge request !2

Franz Liedke authored Jul 21, 2018 and Pierre Schmitz committed Jan 02, 2021

Refs #1022.

Franz Liedke authored Jul 21, 2018 and Pierre Schmitz committed Jan 02, 2021

Deprecated since PHP 5.3.

Refs #1022.

Franz Liedke authored Jul 21, 2018 and Pierre Schmitz committed Jan 02, 2021

Deprecated since PHP 5.3.

Refs #1022.

Franz Liedke authored Jul 21, 2018 and Pierre Schmitz committed Jan 02, 2021

Fixes #1023.

Franz Liedke authored Jul 20, 2018 and Pierre Schmitz committed Jan 02, 2021

Available since PHP 5.4.
See http://php.net/_server.

Refs #1022.

Franz Liedke authored Jul 20, 2018 and Pierre Schmitz committed Jan 02, 2021

It's no longer needed in PHP 5.x.

Refs #1022.

Franz Liedke authored Jul 20, 2018 and Pierre Schmitz committed Jan 02, 2021

The old syntax is no longer needed for PHP4 compatibility, and the
return values never made sense in the first place.

Fixes #1073.

Franz Liedke authored Jul 18, 2018 and Pierre Schmitz committed Jan 02, 2021

Refs #1022.

Franz Liedke authored Jul 18, 2018 and Pierre Schmitz committed Jan 02, 2021

Refs #1022.

Franz Liedke authored Jan 13, 2018 and Pierre Schmitz committed Jan 02, 2021

This fixes deprecation warnings in PHP 7.2, however it also means
we now require at least PHP 5.3 (about time, eh?).

* Before closures, PHP offered create_function(), which is now
  deprecated.
* Instead of the deprecated mcrypt extension, we can use the
  native random_bytes() function in PHP 7+.

Fixes #1109.

Wildcard search queries such as "*linux" will result in a massive database load
as no index can be used. We disable this feature for now.

Problems seem to be resolved.

https://bugs.archlinux.org/task/48628

This reverts commit 14bf5c56.

https://bugs.archlinux.org/task/48628

Signed-off-by: Florian Pritz <bluewind@xinu.at>

We set this server wide and having it in the fluxbb code makes no sense.
Signed-off-by: Florian Pritz <bluewind@xinu.at>

Responsive