Java-Firebird SQL
843859Dec 23 2009 — edited Jan 9 2010Hello. I am not certain this is the right forum, but hopefully I can receive some help.
I have an application that does several database searches on an inventory-keeping database, and all the searches together take about 30 seconds. The searches require user input (3 parameters: Part #, "From" date, and "To" date), so they must be executed after the application is already launched.
My question might be a bit confusing... But is there any way to transfer the data I need to Java objects and then execute the SQL off of that? Is the solution I'm thinking about practical? My concern is: Users like to see "loading" at the front of the program, when they click to load the program. No one likes to wait in the middle of the program. I would like for the program to do most of the heavy lifting up front, but like I said, it requires user-input. The database is massive, which is one reason why things take so long.
Any advice would be very welcome. I am a moderately experienced Java developer, and a not-so experienced database programmer.
Thank you in advance.