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
