[Support request] Database type and collation

[Anthony]

I wanted to confirm, when I create my database to use with WordPress and GeneratePress,

should the database type be MyISAM,

and the collation: utf8mb4_general_ci

is the recommended settings to use?

[Leo]

Hi there,

There are no recommended settings to use as GP doesn’t do anything special here.

Things like these are generally handled by WordPress and not the theme.

Hope this helps 🙂

[Anthony]

I am still a bit confused. I know GeneratePress is not directly concerned with the database, but it runs on WordPress which is dependent on the database.

For example, I am reading in some places that using InnoDB for your WordPress database is better than using MyISAM type?

Can you tell me what you would recommend for best performance and fewer issues?

Thank you.

[Leo]

I am reading in some places that using InnoDB for your WordPress database is better than using MyISAM type?

In that case you should try InnoDB and see if you encounter any issues.

As long as the database type works for WP, it should not generates any issues with GP.

[Anthony]

Just curious. What do you guys use for your database?
MyISAM or InnoDB?

What about Collation type?

[Leo]

I checked with Tom on this and he has no idea what we are using – so it’s safe to say that we don’t have a specific recommendation on this.

Sorry about that.

[Author]

Posts