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
>
>
>
>
>
>
|
