"Martin Bowes" <martin.bowes@[EMAIL PROTECTED]
> wrote in message
news:mailman.0.1215687569.2682.info-ingres@[EMAIL PROTECTED]
> Hi Everyone,
>
> I've finally managed to pivot that damn table! It takes 12hours, and
> builds a 145000 row table that is about 800columns wide.
>
> I tested 10 cases manually across the full spread of columns, I now dare
> anyone at work to prove me wrong. Proof by inducing fear.
>
> The boss likes it so much...I now have to do the same thing to three
other
> tables!
>
> All of which is done just to show an Oracle DBA that his assertion 'Only
> Oracle could do this' was complete crap!
>
> Marty
Yes, but how long before you get:
"Great job, Martin, but the data gets out of date, so please could you
update this every hour, with no downtime? Don't worry, we don't need this
straight away - Monday will do."
;-)
Paul
[I still think it's wrong to have a table with 800 columns and your users
could probably handle the data better another way - I wonder what the
column
names are - I suspect normalisation isn't really an issue here (not a
criticism of you BTW).]
> -----Original Message-----
> From: Martin Bowes
> Sent: 08 July 2008 08:44
> To: 'Ingres and related product discussion forum'
> Cc: 'CB'
> Subject: RE: [Info-Ingres] Maximum query length
>
> Hi Carolyn,
>
> By induction...of fear.
>
> I build a test case on a very specific sample of the data, prove it
works
> for that...
>
> Make a bigger sample, show it works for that...
>
> Do the lot, and then demand angrily that it works and scare the crap out
> of anyone who wants to prove me wrong.
>
> Marty
>
> PS. I believe in computer systems that are big enough to bludgeon a
small
> whale to death.
>
> -----Original Message-----
> From: info-ingres-bounces@[EMAIL PROTECTED]
> [mailto:info-ingres-bounces@[EMAIL PROTECTED]
On Behalf Of CB
> Sent: 07 July 2008 15:47
> To: info-ingres@[EMAIL PROTECTED]
> Subject: Re: [Info-Ingres] Maximum query length
>
> i'm curious to know how you can possibly know if you are getting the
> correct answers back!
>
> cb
>
>
>
> Martin Bowes wrote:
>> Hi Jürgen
>>
>> I'm pivoting a 75million row table. The new table will have something
in
>> the order of 800 columns.
>>
>>
>>
>> It makes for some chunky sql.
>>
>>
>>
>> Marty
>>
>>
>>
>> *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
>>
>>
>>
>> Hi Martin,
>>
>> just a question, why and what for do you need a query that long ?
>> Sorry, for being curious.
>>
>> Jürgen
>>
>>
>>
>>
>>
>>
>>
>> Hi everyone,
>>
>>
>>
>> Well after a lot of editing.and correcting.and more editing.
>>
>>
>>
>> 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!
>>
>>
>>
>> Now to see what execution time is like.and then just pray the query
>> returns the correct answers!
>>
>>
>>
>> Marty
>>
>>
>>
>> *From:* Martin Bowes
>> *Sent:* 05 July 2008 12:16
>> *To:* Ingres and related product discussion forum
>> *Subject:* Maximum query length
>>
>>
>>
>> Hi everyone,
>>
>>
>>
>> Is there a maximal query length in terminal monitor? If so what is it?
>> Can it be extended by a configuration parameter?
>>
>>
>>
>> Martin Bowes
>>
>>
>>
>>
>>
>>
> _______________________________________________
> Info-Ingres mailing list
> Info-Ingres@[EMAIL PROTECTED]
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
>
|
