Hello I am seeking guidance for a project that requires the use of a database.
Obviously I will be programming in Java!
my question really is:
what is the best database that can be used with Java?
My program will be a desktop application which will use the database locally, so no need to make queries over the internet. The program will also be using a very large database, multiple tables and millions of rows, and it will(should) be making hundreds of queries in short periods of time(multi-threading).
I've tried to get information on databases like javaDB, H2, and Derby which are all written in pure java as far as I know, what I really want to know is which one would meet my requirements the best?(doesn't have to be in the list above)
Also since my application should have very high performance, what type of computer would be most suitable for the application?
Any other tips would also be greatly appreciated.
Thanks in advance! :)