db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: maximum file size
Date Fri, 10 Nov 2006 16:20:02 GMT
> I am  curious about one thing though: Why would it not be a good idea to use multiple
tables? 

I think that your proposal and Michael's proposal were quite
similar. Michael was observing that if you went one step
further, and put the multiple tables into multiple databases
on multiple machines, then your application could execute
the queries against the various table "pieces" in parallel,
and get a shorter elapsed time for the overall query.

thanks,

bryan


Mime
View raw message