…to demonstrate the power of Shard-Query it is important to test complex queries involving joins and aggregation. A star schema is the…Query to vastly improve the performance of queries which have to examine a large amount of data. Shard-Query includes a loader (loader.php) which can be used to…
Post: Intro to OLAP
July 12, 2010 By 9 Comments
…to answer those queries. Performance challenges with larger databases, and some ways to help performance using aggregation. Using materialized views to automate that aggregation process. Comparing the performance of…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…Query Cache so it once again is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query…complexity dramatically. Fast Invalidation Right now when you update the table all queries have to be invalidated from the query cache… which can take a lot of…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…improve performance of…to compose the complex object which was previously normalized to several tables or perform complex queries finding relationships between objects. Normalized structure and a lot of…
