Hi Larry,
31 tables, 10 indexes and 2 views....And that's before I add the three
tables required to pivot the big table.
Marty
-----Original Message-----
From: info-ingres-bounces@[EMAIL PROTECTED]
On Behalf Of Larry
West
Sent: 07 July 2008 17:59
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Maximum query length
I'm betting Marty's database one table and one table only.....
At 09:44 AM 7/7/2008, you wrote:
>
>"Martin Bowes"
><<mailto:martin.bowes@[EMAIL PROTECTED]
>martin.bowes@[EMAIL PROTECTED]
>
>wrote in message
><news:mailman.329.1215436399.2607.info-ingres@[EMAIL PROTECTED]
>news:mailman.329.1215436399.2607.info-ingres@[EMAIL PROTECTED]
>
>Hi Jürgen
>
>I'm pivoting a 75million row table. The new
>table will have something in the order of 800 columns.
>
>
>
>Ouch. How can you possibly use a table with 800 columns?
>
>
>
>Paul
>
>
>
>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 qquery 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
_______________________________________________
Info-Ingres mailing list
Info-Ingres@[EMAIL PROTECTED]
|
