…time from the “base tables” (those tables on which the view was built) there must be a process…_id, customer_name, sale_when; $ php convert.php demo < sales.sql CALL flexviews.create('demo...then the query would take significantly longer (40+ minutes): mysql> SELECT -> customer_id as `customer_id`, ->…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…background. > Things are different with MySQL. Good design will help … time to do a full data restore, more tables means longer restore times…indexes. Foreign key references may add processing time to inserts, updates, and deletes…> to crawl. > So developing you PHP applications use test database with …
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…longer time than other interactions for many applications, and also we speak about percentile response time…times – mysql, memcache, sphinx, web services etc. For web applications doing processing in a single thread the following simple formula applies wall_time=cpu_time…
