In your organization, who decides what database platform will be utilized for that new application being built? For many groups, that decision is made by the Development Team while for others, it is the Database Team. But, which is best equipped to make that decision? As is usually the case, the answer lies in […]Read more
If you do a quick web search about UUIDs and MySQL, you’ll get a fair number of results. Here are just a few examples:
Storing UUID and Generated Columns
Storing UUID Values in MySQL
Illustrating Primary Key models in InnoDB and their impact on disk usage
GUID/UUID Performance Breakthrough
To UUID or not to UUID?
So, does a well-covered topic […]Read more
From time to time you may have experienced that MySQL was not able to find the best execution plan for a query. You felt the query should have been faster. You felt that something didn’t work, but you didn’t realize exactly what.
Maybe some of you did tests and discovered there was a better execution […]
Creating an index on a MongoDB collection is simple; just run the command CreateIndex and that’s all there is to it. There are several index types available, and in a previous post, you can find the more important index types: MongoDB index types and explain().
The command is quite simple, but for MongoDB, building an […]