Hi Clark, Derby does not have this feature. You might try putting your big tables in a separate, on-disk Derby database and select from them using restricted table functions. See the ForeignTableVTI attached to https://issues.apache.org/jira/browse/DERBY-4962
Hope this helps, -Rick On 9/1/11 5:33 AM, 鲍少明 wrote: > I mean if one table holds a lot of data, then it cannot be all in memory. > the latest version of hsql of its memory mode allows only keep like 8M > data in memory but others > be kept in disk. This feature looks very useful. > > 2011/9/1 鲍少明 <[email protected] <mailto:[email protected]>> > > Hi Guys, > Is there any feature in Derby in its memory mode like Cache table > in hsql? > I find this feature very important to us , especially there is > some table which holds a lot of table, > not suitable to be a pure memory table. But I want to still keep > the other tables in memory mode. > Is that possible? > Thanks, > Clark > >
