legolas wood wrote:
Hi
Thank you for reading my post.
We have planned to use Derby embedded for our application internal data storage.
Here I have some questions which any answers could be helpful about them.
- We need highest performance, Should we use stored procedure?
Hi Legolas,
In the embedded case, I don't think that stored procedures will give you
a performance boost. However, user-coded functions could boost your
performance. You can see significant performance improvements by
wrapping your filtering logic in functions and wiring the functions into
your queries.
- We will encrypt the database using derby Encryption mechanism, will it cause
performance problem?
In general, I think that there's a trade-off between security and
performance. I don't have numbers on the performance of encrypted
databases. Perhaps someone else could offer specifics.
- Is it correct that we can include a jar file or some Java classes into the
database? if it is correct, what is its use?
Yes, this is true. Please take a look at the "Loading classes from a
database" section of the Derby Developer's Guide.
Regards,
-Rick
Thank you very much.
