0

I am writing a java app with an embedded Derby DB. Because the storage is going to be massive, the db file as well grows huge.

I wonder if the db could be switched to new file or segment once a certain limit is reached.

Is this achievable with Apache Derby?

sabbir
  • 686
  • 1
  • 9
  • 15
  • What is the "certain limit" that you are concerned about? – Bryan Pendleton Nov 12 '13 at 14:57
  • The database is stored in multiple files, but there is just one file per table or index - see https://db.apache.org/derby/docs/10.10/devguide/cdevdvlp40724.html – greg-449 Nov 12 '13 at 18:52
  • @BryanPendleton by certain limit, I mean after the file has reached some size, I want to switch to another file – sabbir Nov 13 '13 at 01:16
  • Well, since each table is indeed its own file, you could rename your existing table and create a new table with the same columns. Then your existing data would remain in the existing file, and the new table would create a new file. – Bryan Pendleton Nov 13 '13 at 17:57

0 Answers0