Jim, I'll jump into the fray on this. Appreciate the sys_table calc of max row size in a specific table.
I've a problematic table with 140 columns, some of which are of Note datatype, which have for sometime begged for a redesign. By and large the multitude of programs hitting this table work well without issue, but, using this Select statement yields a length of nearly 7 times max allowed - 27002 bytes! "... work well without issue" - living on borrowed time, evidently - interesting! -Brad Davidson -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of James Bentley Sent: Tuesday, July 08, 2008 2:58 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Database Limits, again? Karen, See my previous posting on this thread. But here goes: Real 434 columns x 4 = 1736 Date 62 columns x 4 = 248 Integer 2 columns x 4 = 8 Text 1 62 columns x 4 = 248 (text occupy min 4 bytes) Text 8 186 columns x 8 = 1488 Text 15 1 column = 16 (text occupies even number bytes TOTAL ........ 3744 for 746 Columns Seems within limit of 4092 bytes Try the following command at the R>; SELECT (SUM(SYS_LENGTH)) FROM SYS_COLUMNS WHERE SYS_TABLE_ID IN (SELECT SYS_TABLE_ID FROM SYS_TABLES WHERE SYS_TABLE_NAME='yourtablename') Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 --- On Tue, 7/8/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Subject: [RBASE-L] - Re: Database Limits, again? > To: "RBASE-L Mailing List" <[email protected]> > Date: Tuesday, July 8, 2008, 4:02 PM > I don't know how to figure out how many bytes TEXT > columns would take. > Here's the final count. BTW: I removed one of the > columns so I'm at 747 > > Real 434 columns 1736 @4 > Date 62 columns 248 @4 > Integer 2 columns 8 @4 So thru these 3 > we have 1992 > Text 1 62 columns > Text 8 186 columns > Text 15 1 column > > Anyone fill in byte sizes for me? > > No, I don't have a copy of V8 to play with. > > Karen > > > > > Karen, > > > > The column limit is 800 in 7.5 and 7.6....not sure > what it was in 7.1. > > > > I may be all wet here, but I think the issue is the > row size limit. You > > say a lot of the columns are REAL, for which rbase > reserves 4 bytes of storage. > > Others, like Double take up 8 bytes. So it's > possible with 748 columns > > times X bytes - you're already close to or above > your 4,092 bytes for the row > > size limit. It's possible......you'd have to > do the math. Can you try it with > > V8? > > > > Dawn > >
