All very true, Jim - I've put off restructuring this table for some time! Thanks for your reply.
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of James Bentley Sent: Tuesday, July 08, 2008 3:34 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Database Limits, again? Brad, NOTE data types throw all kinds of calculation off since depending on the structure part of the NOTE content are not stored in the row but else where in the ".RB2" file. Apparently the value stored in the SYS_COLUMNS table for NOTE data type is nte maximum value of 4088. You will note that discussions on this list offten suggest you do not incorporate NOTE columns in regular tables involving other values but keep them in there on table with a PRIMARY KEY value referenceing the main table. There is also another reason for not incorporating notes in the main table. Automatic repair facilities supplied by RBase such as AUTOFIX and RSCOPE often can not automatically repair tables that include NOTE columns. I learned that lesson the hard way back when I think it was v3.x or v4.0. I had a pointer problem in my database involving rows with an embedded NOTE column. No curent back up and cross linked sectors for the file. I won't bore you with what we had to do to recover the addressed in our database. To this day I amnot sere we ever recovered information about all the members we had on that data base. Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 --- On Tue, 7/8/08, Brad Davidson <[EMAIL PROTECTED]> wrote: > From: Brad Davidson <[EMAIL PROTECTED]> > Subject: [RBASE-L] - Re: Database Limits, again? > To: "RBASE-L Mailing List" <[email protected]> > Date: Tuesday, July 8, 2008, 5:13 PM > 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 > > >
