Jim,
Why not use a dynamic view? Any "permanent" view is subject to change. The downside to using an on-the-fly - read "temporary" - view is that if your underlying tables change, you may have to change the code that creates the temporary view. The upside is that your temporary view is immune to irrelevant changes in the underlying table structures. Honestly, I don't really understand why anyone would use a permanent view any longer. The only reason we continue to have them in our database is the effort that would be required to make them all temp views. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Monday, December 28, 2009 3:18 PM To: RBASE-L Mailing List Subject: [RBASE-L] - opinions on views If I use a report based on a view every day, is it better to have a predefined view (as I have now) or create one on the fly? Is there really a difference in speed or other processing functions that one would be better than the other? I have the latest 7.6. Jim
