Jim: > A view is no more or less efficient that the queries that > make it up. Each > time you invoke the view, you repeat all the joins.
That is what I was afraid of. With the large number of tables I have, the joins are going to take a lot of cycles to run. > Your solution of the summary table is actually a good one in > many instances, > especially if it's not vital that it contain the most up-to-date data. I think I will go that direction. It will be OK for the summary data to be delayed by a short interval. Thanks, Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL driven app on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org