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/[email protected]
