IMPORTANT NOTE: I have received many answers, and I thank you all. But all the answers are more comments than answers. My question is related to the number of requests for an RDBMS. An experienced person told me that MySQL has fewer hits than Firebird. I would like the answer to remain in the same area. I agree that this is not the first thing to consider, there are many others (application design, network settings, protocol settings ...), in any case, I would like to get an answer to my question, not a comment. By the way, I found the comments very helpful. Thank.
When the latency is long ("it takes time to check the server"), server transitions make a difference.
Now I do not want to focus on the circuits created in programming, but in the circular transitions that occur “under the hood” in the DB + Protocol + DataAccessLayer block.
I was told that FireBird has more hits than MySQL . But this is the only information I know.
I currently support MS SQL, but I would like to modify RDBMS, so to make the right choice, I would also like to include this item in “my RDBMS comparison performance matrix” to understand which one is the best RDBMS alternative to MS SQL .
So the bold sentence above will make me prefer MySQL for Firebird (for the concept of roundtrips, not at all), but can anyone add some information?
MS SQL, ? - "" , :
MS SQL, MySql, Postegresql, Firebird ( Oracle, , , ).
MySql ( stackoverflow) 100% . , , PostgreSQL Firebird.
:
- , , :
MSSQL: 3;
MySQL: 1;
Firebird: 2;
Postgresql: 2
( 1 , 2 , 3 ). , , ,
Update:
Delphi, DevArt DAC (UNIDAC), - " " , , , RDBMS.
:
( - ), , " ", . "" " " " " " ". "".