…, Flexviews includes a MySQL stored procedure API, called the SQL_API which is used to define the view. These stored procedures maintain the Flexviews data…. You should always use the stored procedures to modify the dictionary. Do not modify it directly. convert.php You are probably unfamiliar with…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… small tables… but not for larger ones. First problem was PHP script generating the table took 10GB of RAM and was… of swap space) like crazy. Why ? Because by default mysql_query uses mysql_store_result C library call and buffers all result set… much more efficient. Another alternative is of course to use MySQL Stored Procedures which can be fit to do this simple job. The…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
… ODBC with escaping code that is mature and thoroughly tested. PHP‘s PDO library does something similar, interpolating parameter values into… dynamic SQL in stored procedures extensively. They found that it was awkward because of the limits of the procedure language MySQL offers, and also…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… such as PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes – now there… we do not get major regressions. I’m saying about Stored Procedures which were released without proper development and debugging support. These… inside who can figure things out and even patch MySQL if needed. So MySQL went to chase Enterprise market and develop enterprise…
Comment: A micro-benchmark of stored routines in MySQL
August 16, 2009 By 7 Comments
… found that writing stuff in PHP was about ten times faster. If you add in that MySQL stored procedures don’t have a debugger…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… simple to use than SAN, MySQL is more simple to use than Oracle or DB2, PHP is more simple than Java. Even… with transactions an some with clustering) with support of partitioning stored procedures views and a lot of stuff. Think how much freedom… best isolated of MySQL source leads the pack – there are bunch of interfaces to talk to MySQL cluster as PHP session storage or…
Post: Percona Welcomes Justin Swanhart
May 26, 2010 By 2 Comments
… team of consultants. Before joining Percona, Justin worked as a MySQL DBA at Gazillion, Yahoo, and Kickfire. Justin has become a… stored procedure managed solution for materialized view creation and maintenance in MySQL 5.1 as well as instrumentation-for-php, a suite of PHP classes…
Comment: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
Bill, nice post. To whom it may concern: I wrote a stored procedure that tests for foreign key constraint violations. You can find it here: http://forge.mysql.com/tools/tool.php?id=11
Comment: Watch out for your CRON jobs
October 16, 2009 By 19 Comments
Sheeri, I am mainly speaking about shell/perl/php/python/ruby scripts a lot of systems are running. If you just need simple query/stored procedure run you can use MySQL events of course.
Comment: MySQL wins C'T Database Contest
August 31, 2006 By 27 Comments
… no cache – there is something in this tests that is MySQL-specific. For instance, 3664 op/min is around 60 op… least, it should be a stored procedure, otherwise we just compare drivers and essentials of Java vs PHP. If someone can show the…
