…(MVs). An MV is essentially a cached result set at one point in time. The contents…sale_when; $ php convert.php demo < sales.sql CALL flexviews.create(‘demo’, ‘dashboard_customer_sales’, ‘INCREMENTAL’); SET @mvid := LAST_…latter. I also showed how you can combine both types of views together. The …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…(ICE) performs in combination with Shard-Query. Data set It was important to choose a data set that was large …. This same SQL script was used in the Shard-Query tests. For the baseline, the results and response … of data. Shard-Query includes a loader (loader.php) which can be used to either split a …
Comment: ORDER BY ... LIMIT Performance Optimization
April 2, 2007 By 93 Comments
…select five people at random who have a certain setting on their profile. I can’t use max …0′ AND profile_display_name””; … Then use PHP to shuffle the resulting array and take the first five items: shuffle…id IN ($in_sql) LIMIT 5″; On my 30k row table the new solution ran in a combined .0147 secs,…
