db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Van Couvering <da...@vancouvering.com>
Subject Re: Limit on number of rows a table can hold?
Date Wed, 21 Feb 2007 18:49:19 GMT
Hi, Nurullah.  You say that you spread the database over a bunch of 
machines.  Does that mean you're running multiple Derby instances, each 
embedded into a process running on a different machine?  Or do you have 
one Derby instance that holds a 20gb table?

David

Nurullah Akkaya wrote:
> i have a 20 gb table with over 100 million rows thats growing 1 million 
> rows per day. i think it depends on what you trying to achieve my 
> application distributes a big database over a bunch of machines so 
> running a separate heavy server process was causing me problems and 
> switching derby saved a lot of resources and application is much faster. 
> but i am sure there is some body else's application that will be much 
> faster under DB2 or oracle.
> 
> 
> 
> Nurullah Akkaya                                                   
> 
> 
> 
> 
> On Feb 20, 2007, at 2:54 PM, Tim Troup wrote:
> 
>> 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
> 

Mime
View raw message