…MySQL stored procedure API, called the SQL_API which is used to define the view. These stored procedures…rows in set (0.00 sec) Using the dictionary The following SQL is dynamically generated by the flexviews.get_sql() function call. This function…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
Post: A micro-benchmark of stored routines in MySQL
August 16, 2009 By 7 Comments
…stored routines are in MySQL? I just ran a quick micro-benchmark to compare the speed of a stored function…procedure…stored function. mysql> delimiter // mysql> create function speaks_english(c char(3)) returns integer deterministic > begin > declare res int; > select count…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
…in-cache scenario I created a table with just 10000 rows and wrote little stored procedure to make timing easier: mysql> DELIMITER // mysql> CREATE PROCEDURE…row by row” processing which means function calls for each row. Lets see if we do some row function on those 10.000.000 rows…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
…in statement mode. Â The row-based format does offer advantages particularly if triggers or stored procedures are used, or if non deterministic functions… count(*) from t1; +———-+ | count(*) | +———-+ |Â Â Â 65536 | +———-+ 1 row in set (0.02 sec) My test setup includes a MySQL…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
…helpful for MySQL …of rows now…stored procedure calls are not, even if stored procedure would simply preform select to retrieve data from table. Avoid comment (and space) in…functions such as UUID(), RAND(), CONNECTION_ID() etc it will not be cached. Table level granularity in… cached. Counting …
