1. Consider MySQL partitioning Partition according to certain rules. Avoid the scheme of splitting tables, which is very inefficient. Partition 。避免分表这种方案，效率很低。

   学习成本较低，达到目的较快
   

2. 如果查询量大，laravel无缝支持elasticsearch，将elastic作为查询方案效率会更好。

   使用elastic有一定的学习成本
   

laravel的elasticsearch rrreee

• If the query volume is large, laravel seamlessly supports elasticsearch, and it will be more efficient to use elastic as a query solution.

  rrreee

laravel’s elasticsearch plug-in, both are required.
laravel/scout https://packagist.org/package...