Performance issues

[adam-qiang]

Laravel Version

11.20.0

PHP Version

8.3.10

Database Driver & Version

MySQL5.7

Description

There are performance issues when using Schema:: hasTable(), which can generate slow SQL and cause a surge in database load (see performance report in the following figure)

Steps To Reproduce

Schema:: hasTable()

[alecpl]

information_schema.tables is the most standard way of doing that, but it is a view on a multiple tables and it can be slow indeed. If we really wanted to change that using some system tables directly might be one solution. There's also table_exists added in MySQL 5.7, but I have no idea about its performance.

That being said, I use Schema features only in migration where the performance is not that big of a deal.

[adam-qiang]

information_schema.tables is the most standard way of doing that, but it is a view on a multiple tables and it can be slow indeed. If we really wanted to change that using some system tables directly might be one solution. There's also table_exists added in MySQL 5.7, but I have no idea about its performance.

That being said, I use Schema features only in migration where the performance is not that big of a deal.

If it's just a simple way to determine whether a table exists, and whether there is a more lightweight function? (I've written a function myself as a substitute for it)