109 reputation
2
bio website
location
age
visits member for 2 years, 7 months
seen May 6 '12 at 6:13

May
6
comment PostgreSQL vs MySQL benchmarks when a 2nd level cache is included
But this begs the question implicit in what I'm asking-- does a 2nd level cache affect performance equally for a system backed by MySQL/Postgres? The 2nd level cache only affects certain types of queries, for example queries which you search by ID (eg select * from table where id in (2,3)). Let's suppose hypothetically that MySQL was fast as those queries and Postgres was not. If you then enable the 2nd level cache, then whatever tradeoff Postgres might've made that resulted in slower id-in query would be very much worth it for a 2nd-level cache enabled system.
May
4
awarded  Student
May
4
awarded  Editor
May
4
revised PostgreSQL vs MySQL benchmarks when a 2nd level cache is included
more hibernate agnostic-ation
May
4
asked PostgreSQL vs MySQL benchmarks when a 2nd level cache is included