…improve performance of almost all queries by spreading them over more than one physical server. This is called “scaling out” and it allows Shard-Query to vastly improve…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…and you’ll see why below. So what I think could be done with MySQL Query Cache so it once again is appealing to improve performance…query depends on. If not you need to re-generate the query result. Removing of stale queries in this case can be done through some sort of…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…in works which would improve performance of index accesses/index scans. For example retrieving index values first and then accessing rows in…
Post: Intro to OLAP
July 12, 2010 By 9 Comments
…to MDX queries and the kind of SQL which a ROLAP tool must generate to answer those queries. Performance challenges with larger databases, and some ways to help performance…
