SQL Cache Method

At Database Setup stage, I know there is a red statement right under Optional Settings saying it is recommended to leave the settings as is unless you have a specific reason for altering them. For SQL Cache Method, default is none. But I heard that the use of a cache generally increases the speed of the site/queries, so would it be better to select “database” for the SQL Cache Method instead of default “none”? Or would selecting “database” cause any problem? Thanks!

Depends on if your server is slow processing database items or not
You can check by enabling parse time in the footer in your admin