We have web based application (Oracle DB, Weblogic middle tier) and a applet based application running on the browser.
We have a requirement to Load images from the database (stored as blob) to the client browser and the users can do the lookup on images when needed.
We need this to perform well, so there is no delay for the user experience. We have 2 options:
1. Load the images from the database to the Application Server and keep it. When the client request from the browser comes, download it from the application server.
2. Load the images (asynchronosly) when the user logs into the application and download them to the Client machine? Is this possible? Especially give that it is stored in the database as binary objects?
And then load for the user from the client box itself, upon request.
If 2nd option is possible, which once is recommended?