Even if you need billions of rows, are you sure you want that in an embedded database? I'm the biggest fan of Derby I know, but if I'd say if you're talking about accessing possibly terabytes of data, maybe you should spring for a complete industrial strength RDBMS.
ry > > Billions of rows? > > Sounds like you'll need to rethink your design. > > Sure you can do it, but how efficient will it be? > > > > -----Original Message----- > > From: Tim Troup [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, February 20, 2007 6:55 AM > > To: Derby Discussion > > Subject: Limit on number of rows a table can hold? > > > > Hi, > > > > Is there a limit on the number of rows a table can hold? > > I am planning on using derby as the RDBMS for a system that will > > require tables to hold billions of rows. > > > > Thanks, Tim > > > >
