Report or View ?

#1 (**permalink**) 04-19-2008, 10:12 PM

This is a multi-part message in MIME format.

------_=_NextPart_001_01C42939.47F5A969
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Quick question. We currently have space problems. The MIS users =
(when they run large reports) create tables with subsets of data, and =
then run their final queries on these subsets.

=20

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 ?

=20

=20

=20

=20

=20

=20

Dirk Moolman

Database and Unix Administrator

MXGROUP

=20

=20

"People demand freedom of speech as a compensation for the freedom of =
thought which they seldom use."=20

-Kierkegaard=20

=20

________________________________

<< ella for Spam Control >> has removed 449 Spam messages and set aside =
307 Newsletters for me
You can use it too - and it's FREE! www.ellaforspam.com=09

------_=_NextPart_001_01C42939.47F5A969
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">

<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">

<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color

urple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 77.95pt 1.0in 77.95pt;}
div.Section1
{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Quick question.      We currently have =
space problems.  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 =
?

 

 

 

 

 

 

Dirk Moolman

Database and Unix Administrator

MXGROUP

 

 

"People demand freedom of speech as a compensation for the =
freedom
of thought which they seldom use." 

-Kierkegaard 

 

</div>

</body>

</html>
 <hr><table border=3D"1" cellpadding=3D"8" =
cellspacing=3D"0" bgcolor=3D"#FFFF99" bordercolor=3D"#999999"><tr><td =
align=3D"center">&lt&lt ella for Spam Control &gt&gt =
has removed 449 Spam messages and set aside =
307 Newsletters for me You can use it too - and it's =
FREE!&nbsp&nbsp<a =
href=3D"http://www.ellaforspam.com">www.ellaforspam.com</a></td></=
tr></table>=00
------_=_NextPart_001_01C42939.47F5A969--
sending to informix-list

#2 (**permalink**) 04-19-2008, 10:16 PM

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/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode