I find there is a "Oracle" group but I am not using Oracle at all. So I am posting this here. Hope you can help.
I am new to stored procedure and new to
Java's "PreparedStatement/CallableStatement". What I have done before is just straightforward java sql "Statatement". So I need your input here ---
In my first page, I let user pick some "product type", then in the 2nd page there is a "Product List" picklist, the content is dependent on what "Product type" user chooses in the 1st page. This involves a simple SQL, now the problem is the database contains SO MUCH data and makes it very slow. Fortunately I know there are only a few choices for "Product Type", so what I want is -- Can I pre-select out the results so it immediately shows me the "Product List" instead of going through the huge database whiel user is waiting for the 2nd page to come out ?
How to do that ?
Many thanks.