This is a multi-part message in MIME format.
------=_NextPart_000_0041_01C8E059.2B03F550
Content-Type: text/plain;
charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
RE: [Info-Ingres] subpartitions and date functions"Martin Bowes" =
<martin.bowes@[EMAIL PROTECTED]
> wrote in message =
news:mailman.329.1215436399.2607.info-ingres@[EMAIL PROTECTED]
Hi J=C3=BCrgen
I'm pivoting a 75million row table. The new table will have something =
in the order of 800 columns.
=20
Ouch. How can you possibly use a table with 800 columns?
Paul
It makes for some chunky sql.
=20
Marty
=20
From: info-ingres-bounces@[EMAIL PROTECTED]
=
[mailto:info-ingres-bounces@[EMAIL PROTECTED]
On Behalf Of =
email@[EMAIL PROTECTED]
Sent: 07 July 2008 13:39
To: info-ingres@[EMAIL PROTECTED]
Subject: Re: [Info-Ingres] Maximum query length
=20
Hi Martin,
just a question, why and what for do you need a query that long ? =
Sorry, for being curious.
J=C3=BCrgen
=20
Hi everyone,
=20
Well after a lot of editing=E2=80=A6and correcting=E2=80=A6and =
more editing=E2=80=A6
=20
The query has reached 66432 characters (including indenting). It =
seems the only limit is what memory is given to the opf. I bumped mine =
from 12,000,000 to 50,000,000 and the query optimizes within a few =
seconds!
=20
Now to see what execution time is like=E2=80=A6and then just =
pray the query returns the correct answers!
=20
Marty
=20
From: Martin Bowes=20
Sent: 05 July 2008 12:16
To: Ingres and related product discussion forum
Subject: Maximum query length
=20
Hi everyone,
=20
Is there a maximal query length in terminal monitor? If so what =
is it? Can it be extended by a configuration parameter?
=20
Martin Bowes
=20
=20
=20
------=_NextPart_000_0041_01C8E059.2B03F550
Content-Type: text/html;
charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40"
xmlns:v =3D=20
"urn:schemas-microsoft-com:vml" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word" xmlns:m =3D=20
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD><TITLE>RE:
=
[Info-Ingres] subpartitions and date functions</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.6000.16674" name=3DGENERATOR>
<STYLE>@[EMAIL PROTECTED]
{
font-family: Calibri;
}
@[EMAIL PROTECTED]
{
font-family: Tahoma;
}
@[EMAIL PROTECTED]
Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 72.0pt 72.0pt =
72.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New =
Roman","serif"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New =
Roman","serif"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New =
Roman","serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: =
"Times New Roman","serif"; mso-style-priority: 99; mso-margin-top-alt: =
auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: =
personal-reply
}
..MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: ex****t-only
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=3DEN-GB vLink=3Dpurple link=3Dblue bgColor=3D#ffffff>
<DIV>"Martin Bowes" <<A=20
href=3D"mailto:martin.bowes@[EMAIL PROTECTED]
">martin.bowes@[EMAIL PROTECTED]
>=
>=20
wrote in message <A=20
href=3D"news:mailman.329.1215436399.2607.info-ingres@[EMAIL PROTECTED]
">news:mailman.329.1215436399.2607.info-ingres@[EMAIL PROTECTED]
>...</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV class=3DSection1>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'">Hi=20
</SPAN>J=C3=BCrgen<BR><BR><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'"><o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'">I'm=20
pivoting a 75million row table. The new table will have something in =
the order=20
of 800 columns.<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'"><o:p> </o:p></SPAN></P></DIV></BLOCKQUOTE>
<P class=3DMsoNormal dir=3Dltr><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'"><o:p><FONT=20
color=3D#000000 size=3D2>Ouch. How can you possibly use a table with 800 =
columns?</FONT></o:p></SPAN></P>
<P class=3DMsoNormal dir=3Dltr><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'"><o:p></o:p></SPAN><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'"><o:p><FONT=20
color=3D#000000 size=3D2></FONT></o:p></SPAN> </P>
<P class=3DMsoNormal dir=3Dltr><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'"><o:p><FONT=20
color=3D#000000 size=3D2>Paul</FONT></o:p></SPAN></P>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'"><o:p><FONT=20
color=3D#000000 size=3D2></FONT></o:p></SPAN> </P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'">It=20
makes for some chunky sql.<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'">Marty<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<DIV class=3DSection1>
<DIV=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: =
#b5c4df 1pt solid; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: =
medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=3DMsoNormal><B><SPAN lang=3DEN-US=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
'Tahoma','sans-serif'">From:</SPAN></B><SPAN=20
lang=3DEN-US style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
'Tahoma','sans-serif'">=20
info-ingres-bounces@[EMAIL PROTECTED]
[mailto:info-ingres-bounces@[EMAIL PROTECTED]
<B>On Behalf Of =
</B>email@[EMAIL PROTECTED]
><B>Sent:</B> 07 July 2008 =
13:39<BR><B>To:</B>=20
info-ingres@[EMAIL PROTECTED]
><B>Subject:</B> Re: =
[Info-Ingres]=20
Maximum query length<o:p></o:p></SPAN></P></DIV></DIV>
<P class=3DMsoNormal><o:p> </o:p></P>
<P class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt">Hi =
Martin,<BR><BR>just a=20
question, why and what for do you need a query that long ? =
Sorry, for=20
being curious.<BR><BR>J=C3=BCrgen<BR><BR><BR><BR><o:p></o:p></P>
<DIV class=3DSection1>
<TABLE class=3DMsoNormalTable style=3D"WIDTH: 100%" cellPadding=3D0 =
width=3D"100%"=20
border=3D0>
<TBODY>
<TR>
<TD=20
style=3D"PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: =
blue; PADDING-BOTTOM: 0.75pt; WIDTH: 3.75pt; PADDING-TOP: 0.75pt"=20
width=3D5>
<P class=3DMsoNormal> <o:p></o:p></P></TD>
<TD=20
style=3D"PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; =
PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<DIV>
<P class=3DMsoNormal=20
style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: =
auto"><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'">Hi=20
everyone,<o:p></o:p></SPAN></P>
<P><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'"> <o:p></o:p></SPAN></P>
<P class=3DMsoNormal=20
style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: =
auto"><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'">Well=20
after a lot of editing=E2=80=A6and correcting=E2=80=A6and more=20
editing=E2=80=A6<o:p></o:p></SPAN></P>
<P><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'"> <o:p></o:p></SPAN></P>
<P class=3DMsoNormal=20
style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: =
auto"><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'">The=20
query has reached 66432 characters (including indenting). It =
seems the=20
only limit is what memory is given to the opf. I bumped mine =
from=20
12,000,000 to 50,000,000 and the query optimizes within a few=20
seconds!<o:p></o:p></SPAN></P>
<P><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'"> <o:p></o:p></SPAN></P>
<P class=3DMsoNormal=20
style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: =
auto"><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'">Now=20
to see what execution time is like=E2=80=A6and then just pray =
the query returns=20
the correct answers!<o:p></o:p></SPAN></P>
<P><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'"> <o:p></o:p></SPAN></P>
<P class=3DMsoNormal=20
style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: =
auto"><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'">Marty<o:p></o:p></SPAN></P>
<P><SPAN=20
style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: =
'Calibri','sans-serif'"> <o:p></o:p></SPAN></P>
<DIV>
<DIV=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; =
BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 0cm; PADDING-BOTTOM: =
0cm; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium =
none">
<P class=3DMsoNormal=20
style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: =
auto"><B><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
'Tahoma','sans-serif'">From:</SPAN></B><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> =
Martin=20
Bowes <BR><B>Sent:</B> 05 July 2008 12:16<BR><B>To:</B> Ingres =
and=20
related product discussion forum<BR><B>Subject:</B> Maximum =
query=20
length<o:p></o:p></SPAN></P></DIV></DIV>
<P> <o:p></o:p></P>
<DIV id=3DidOWAReplyText36874>
<DIV>
<DIV>
<P class=3DMsoNormal=20
style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: =
auto"><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: =
'Arial','sans-serif'">Hi=20
everyone,<o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=3DMsoNormal=20
style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: =
auto"><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: =
'Arial','sans-serif'"> <o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=3DMsoNormal=20
style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: =
auto"><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: =
'Arial','sans-serif'">Is=20
there a maximal query length in terminal monitor? If so what is =
it? Can=20
it be extended by a configuration =
parameter?<o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=3DMsoNormal=20
style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: =
auto"><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: =
'Arial','sans-serif'"> <o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=3DMsoNormal=20
style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: =
auto"><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: =
'Arial','sans-serif'">Martin=20
Bowes<o:p></o:p></SPAN></P></DIV></DIV></DIV>
<DIV>
<P class=3DMsoNormal=20
style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: =
auto"><BR> <o:p></o:p></P></DIV></DIV></TD></TR></TBODY></TABLE></DI=
V>
<P class=3DMsoNormal><o:p> </o:p></P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0041_01C8E059.2B03F550--
|
