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
>
