db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stefan B├╝hlmann <stefan.buehlm...@bfh.ch>
Subject Performance Optimization for In-Memory ReadOnly Database
Date Mon, 23 May 2011 19:42:42 GMT
Hi together,

I'm using derby for a dataprocessing application.
SYSCS_UTIL.SYSCS_IMPORT_TABLE is used to import CSV data (around 100mb).
The tables contain huge amount of rows (~100k) with some CLOB (max 60mb)
columns.

The table data is never altered (after the CSV import).

Currently I'm using a in-memory database with pageCacheSize of 2000.

Are there any other tricks to make querying the data more efficient?

Kind Regards

Stefan

Mime
View raw message