Tagged Questions
1
vote
2answers
150 views
Derby/SQL - How to increase performance when left joining and retrieving varchar columns
Through trial and error I found that if I do a left join such as:
SELECT
firsttable.id,
secondtable.id,
secondtable.varcharColumn
FROM
firsttable
LEFT JOIN
secondtable
ON
...
2
votes
1answer
395 views
Derby slows down after 1.2 million records
I'm using a Derby database, mass insertions slow down to 1/4 to 1/6 the speed once there are 1.2 million records (about 6 GB database size, one major table, other tables are tiny). Is that normal? Is ...
1
vote
0answers
62 views
Altering an Apache Derby table's derby.storage.pageSize property after creation
Is it possible to change the derby.storage.pageSize property of an existing table? Or do I have to export my data, drop then re-create the table with the new property, and then re-import my data?
