Re: not more than 128 columns?

fre 2011-04-22 klockan 12:50 -0500 skrev Seb:
> On Sat, 16 Apr 2011 07:46:29 +0200,
> "Simone Krais" <[email protected]> wrote:
> 
> > Dear openoffice team, I am trying to establish an open office database
> > for my work as an anthropologist. I need tables with the size of
> > around 300 columns (data fields). It would be very complicated to
> > spread it into multiple tables since the data is to be evaluated all
> > together.  But with the size of 128 columns I can not go on. What is
> > the problem?  Can you help me?

Yes, upgrade your OpenOffice.org. Recent version of OpenOffice.org Calc
has 2¹⁰ columns (1 024): A-AMJ. Also the number of rows is increased
from 2¹⁶ (65 536) to 2²⁰ (1 048 576).

> 
> I'd seriously reconsider the database design *very* carefully; 300
> fields in a table rarely makes sense.  It will pay off in the long run.
> There's plenty of books out there.  A very good one is: Database Design
> for Mere Mortals by Mike Hernandez.
> 

Good point.

> 
> -- 
> Seb
> 


-- 
Best regards

Johnny Rosenberg

-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help