| Increasing Performance with VIEWS [message #307] |
Mon, 30 October 2006 10:13  |
 Speeple
Messages: 91
Registered: August 2006 |
Member |
|
|
Hi,
I'm working on some blogging software which uses MySQL as a datas tore.
Each archive page, year, month, day can have a tag cloud generated to show the most popular tags for that day.
Currently I'm using a derived table. Then I stumbled across your article "Derived Tables and Views Performance" and tested a query with a VIEW and it was indeed theoretically faster because the number of rows required in the query that used the VIEW was SUBSTANTIALLY lower than that of the derived query.
What I was thinking of implementing was temporay VIEWs each time the tag cloud needs to be generated (every page view  ).
So it would go:
CREATE VIEW for IDs
PERFORM query USING VIEW
DROP VIEW
Remembering this would be performed every page view, for every visitor on every blog hosted (we're talking a lot of VIEWS being created and DROPPED here) - how would it perform? Does this require a lot of IO operations?
Thank you!
Martin Gallagher | Speeple: The latest news
|
|
|
|
Members
Search
Help
Register
Login
Home
