…LIMIT 0 to the SELECT part of the query. convert.php This script takes as … to read from the dictionary directly to determine the contents of the view. mysql> select …to compute this list would take over 40 minutes to execute, because that is how long it takes to create the monthly summary from…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…MySQL command line client was used to execute the a script file containing the 11 queries. This same SQL script was used in the Shard-Query…queries show how performance is improved when Shard-Query adds parallelism when “subqueries in the from…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…from 1988 to 2010′; mysql> use ontime1; Database changed mysql…to 20 nodes. cd shard-query #generate a config for 20 shards (adjust to your number of nodes) php…Execute the test: As seen above, the run_query script will run one more more semicolon terminated SQL statements. The queries…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
…script from command line otherwise APC cache will not work and results will be wrong. So what is about results and how…to cache composed objects which may correspond to multiple MySQL queries. On Selecting from the table I should note MySQL is rather fast selecting from…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
…PHP: $placeholders = join(“,”, array_fill(0, count($params), “?”)); $sql = “SELECT * FROM Bugs WHERE bug_id IN ($placeholders)”; $stmt = $pdo->prepare($sql); $stmt->execute…how to escape input that contains non-printing characters. The standard API function mysql…
Post: Handling big result sets
June 26, 2006 By 13 Comments
…mysql_query() does. So mysql_query buffers all rows on client side. Let’s try our script with mysql_unbuffered_query instead of mysql_query. execution…
