Question : In Derby (an embedded database written in Java which is mostly used for testing or prototyping) there are […]
Tag: derby
Derby slows down after 1.2 million records
Question : I’m using a Derby database, mass insertions slow down to 1/4 to 1/6 the speed once there are […]
Convert Oracle database to Derby
Question : I need to migrate an existing Oracle Database into a Derby one. I want to know if there’s […]
Long JOINS Returns No result all tables have one to many relationship with a particular table [closed]
Question : This question is unlikely to help any future visitors; it is only relevant to a small geographic area, […]
Long JOINS Returns No result all tables have one to many relationship with a particular table [closed]
Question : This question is unlikely to help any future visitors; it is only relevant to a small geographic area, […]
Will Derby, H2, or SQLite give faster load time and/or smaller file size than HSQL?
Question : I have some flat files with the following columns; 3 integers, 3 reals, and 1 varchar(20). For querying […]
Derby/SQL – How to increase performance when left joining and retrieving varchar columns
Question : Through trial and error I found that if I do a left join such as: SELECT firsttable.id, secondtable.id, […]
Long JOINS Returns No result all tables have one to many relationship with a particular table [closed]
Question : This question is unlikely to help any future visitors; it is only relevant to a small geographic area, […]
Does making a field unique make it indexed?
Question : If I make a unique constraint on a field, do I also need to make an index on […]