On 5/24/2012 11:33 AM, Stephen Russell wrote: >> From TSQL experience you can create the view and just put in a where > clause with it. Depending on the view, usually, you will not receive > the entire set of the table(s) and then filter it. > > MySQL I have no idea. > > The other option is to make some SPROCS and let them be in control. > > Now 8480 views sounds excessive! That many sprocs does as well. > > How many tables are in this system?
It's not that many tables really at all. In fact, for these views, they're going against 3 different tables. But there's different criteria at which this data is viewed, and these views create the possible datasets for which the accountants may access/analyze the data, giving them a quick snapshot of the data rather than them having to do a lot of SQL. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
