How to check cost of derby(apache in-memory datadase)

Question

I am using memory database(derby) with spring framework.

I am using that with bunch of annotations and xml. It works nice, but I am not sure my SQL is good enough or needs some optimizations.

Is there anyway to check the cost of SQL with derby? (I already visited derby homepage, but I need more examples) Thanks.

score 0 · Accepted Answer · answered Nov 18 '13 at 14:52

0

The basic techniques for measuring the performance of your SQL are documented here: http://db.apache.org/derby/docs/10.10/tuning/index.html

answered Nov 18 '13 at 14:52

Bryan Pendleton

1 Answers1