Re: Report or View ?

Posted in 2004

Jonathan Leffler — Fri, 30 Apr 2004 06:00:45 GMT — source: Usenet: comp.databases.informix

Dirk Moolman wrote: > This is a multi-part message in MIME format. Don't post MIME. > Quick question. We currently have space problems. Get some more disk space - it is cheaper than your time. (Physician heal thyself - my Sun needs more disk space too.) > The MIS users > (when they run large reports) create tables with subsets of data, and > then run their final queries on these subsets. > > Due to the space issue we cannot create these subsets right now. Will > it be really bad for performance to replace these subsets with views? It depends on how complex those views are. If the alternative is waiting to free enough disk space, then probably the views will be quicker. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/