Re: Is this a record?

Well I can't break that record all in one table, but I have "acquired" a table with 54 columns and EIGHTEEN indexes on it!! Another possible record-breaker is a trigger on a table with 129 columns. The trigger is so large that the way it is retrieved using dbschema, it has 132 levels of parenthesis!! Trying to create it as is on a pre 7.3x engine causes a "-762 Stack overflow occurred during statement parse." error. The solution was to write a Perl script which effectively simplied the expression back to a manageable level of parenthesis. Stuart Knight. Dirk Gunsthoevel <gunstho@uni-muenster.de> on 23/07/99 04:39:39 To: Jon Myatt <jon@webpower.co.uk> cc: informix-list@iiug.org (bcc: Stuart Knight/Australia/Contr/IBM) Subject: Re: Is this a record? Jon Myatt wrote: > > The application I've just inherited has a 154-column table with > SEVENTEEN indexes on it, all in the same dbspace. > > And they're wondering why it's running slowly... > > Has anyone seen worse? > > Jon. Sounds familiar to me... Condolences, Dirk