Importance of database name length

Question

When setting up a database (e.g. in MySQL), how important is the length of the database name?

Is there any (measurable) difference between like my_database_has_a_really_long_name and my_db?

Especially regarding security and performance of queries?

Answer 1

1) Databases often have limits on character length of name values and my cPanel MySQL has a limit of 16 characters.

2) The only other reason for the name is to identify the database. You should be able to identify the database with 16-32 characters.

There is no impact on performance of queries or securities with different names because

i) Performance of queries means that if the length of the database name is effecting performance - well - it's just not going to happen, it's a static string reference of alphanumeric characters. That's it. Processors deal with millions/billions of bits a second, every second, to add a few extra bits to this call is absolutely negligible.

ii) Security wise, the name of the database should never be anywhere near being given out to either the browser or the end user. If there is a security issue involving the name, it's because you've been breached regardless of how long your database name is.