[IceCube!]

Quote:

Originally Posted by dusk Interesting. I believe I might have overdone it.... 27 tables for a roleplay server and I consider making one more for player licenses and their warnings.

In all honesty that's nothing... there are lots of massive MySQL databases out there with dozens, and dozens of tables. As Y_Less said they are likely specialized tables which is a good thing.

If you have specialised tables you only need to load in those tables when they are needed, for example the players vehicles are stored in their garages. They however aren't using their cars, and cruising with other players. You may as well unload this information if not load it at all until they enter the garage expecting to see their cars?

I however think if you have a table for licenses, it would simply be because of neatness and readability. This is not problem, it's not going to affect loading times of your database too much. As for warnings that could be anything, driving warnings? Admin Warnings?

Just keep in mind, the more tables you have; the better arranged your data. The easier it is to load and unload data when necessary and be able to manage the server in better more memory and network conserving ways.