Timeline for Comparing Query Performance Across DBMSs
Current License: CC BY-SA 4.0
7 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Mar 17, 2021 at 6:44 | comment | added | Laurenz Albe | To figure that out, you have to investigate the execution plans. That is a different problem. | |
Mar 16, 2021 at 23:14 | comment | added | unitydeveloper123 | Thank you! I was wondering if you had any idea why a join query I created would be significantly faster in postgreSQL than in MySQL/MariaDB or SQLite (on the magnitude of seconds vs minutes)? This is the only thing I'm still troubled on in my comparison. | |
Mar 16, 2021 at 13:03 | vote | accept | unitydeveloper123 | ||
Mar 16, 2021 at 0:12 | comment | added | Laurenz Albe | I would write a shell script or a little program. | |
Mar 15, 2021 at 20:00 | comment | added | unitydeveloper123 | Could you suggest commands to use for this? I'm just querying local databases from the command line for testing purposes | |
Mar 15, 2021 at 18:19 | comment | added | Rick James | This is a good techinque for a single query on MySQL/MariaDB, too. | |
Mar 15, 2021 at 16:43 | history | answered | Laurenz Albe | CC BY-SA 4.0 |