Materialized Views in MySQL? (aka, Summary Tables / aka, Materialized Views / aka, Flexviews ) + more!!

1
-- Initially I was looking to not hit a product table with hundreds of thousands of products for randomly getting a few with every visit to the
    homepage,
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Views in MySQL are dynamic. What if you want to cache the info so you don't crash the live system with poorly written queries during the day? Too bad and you're SOL, Jack. Here's what MySQL says...

http://dev.mysql.com/doc/refman/5.6/en/create-view.html

.. and above are your prayers answered, as mine were. Open Source just means you have to think harder with less hand holding.

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.