How do I solve the problem that the load data is very slow

Hi,everyone,I have a very frustrating problem.
As shown in the screenshot:

Every time I enter those pages, I need to load data for 30s to 60s,but we don't have too many data.
We use mysql as the meta-database,as shown in the screenshot:
Is there any room for optimization or other solutions? Veison is 0.37.4

Hi @jesse1

Post "Diagnostic Info" from Admin > Troubleshooting.

I would recommend that you upgrade to a later release - we're constantly improving performance.

You say that you don't have a lot of data, but there's 47k columns synced into Metabase - that's quite a lot. There's an issue open about better handling of those endpoints: - upvote by clicking :+1: on the first post

Run the following query:

SELECT AS database_id, metabase_database.engine AS database_engine, count(distinct metabase_table.schema) AS count_schemas, AS table_active, count(distinct AS count_tables, AS field_active, count(distinct AS count_columns
FROM metabase_database
LEFT JOIN metabase_table ON = metabase_table.db_id
LEFT JOIN metabase_field ON = metabase_field.table_id
GROUP BY, metabase_database.engine,,

Is 47K a lot of data?Besides upgrading the version, what other configuration can we do to improve load performance?

@jesse1 I think you're misunderstanding the difference between data and schema. You have a 47k columns in Metabase. That's quite a lot. I'm not talking about rows of data, since you can have millions of rows in each table, Metabase will handle that.

Post "Diagnostic Info" from Admin > Troubleshooting.

Serving requests with HTTPS over HTTP/2 with compression can help, but try upgrading - make sure you have a backup first in case you want to revert.