The Bug Tracker Test
Like most bug trackers, ours has suffered from feature bloat over time, and requires
about 16 queries to display the browse page.
about 16 queries to display the browse page.
None of the queries is particularly difficult – except one of them requires a double
join against the “users” table to get the name of the submittor and who it is assigned to.
join against the “users” table to get the name of the submittor and who it is assigned to.
Frankly, I expected that MySQL would easily win this test – selects and joins are its
bread and butter. So again, I was pleasantly surprised to see that Postgres won this
test handily.
bread and butter. So again, I was pleasantly surprised to see that Postgres won this
test handily.
