How come people use sql instead of just using text files? I just use text files for everything
What are text files if not binary blobs on disk?
What is SQL if not a query layer over a bunch of binary blobs on disk?
Very zen.
This is fake the pid of the younger guy is smaller than that of grandpa
Their age is measured in CPU time
Is this a MySQL specific problem? I have witnessed a few dead queries on Sybase / Oracle / etc
I don’t think its mysql specifically, but for some reason the worst systems I have used, all have mysql/mariadb as a database.
It seems shitty applications gravitate to mysql, use it poorly, then bring a bad name to mysql.
But given all my years of experience with it, MSSQL > Posgresql > Mysql > Oracle
I was a DBA for over 10 years. Postgresql is superior to mssql in most ways. Especially replication.
But that does not mean that mssql is bad. MySQL is, oracle is.
Usually DBMSs have some small capacity to handle requests in parallel so everything slows down, but work is still getting done.
Allergic to Indices? If your database is slow just add more Indices until you have one on every column of every table! :-)
Using subqueries instead of CTEs, scrubs!