aspose file tools*
The moose likes JDBC and the fly likes A Question on effeciency Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "A Question on effeciency" Watch "A Question on effeciency" New topic
Author

A Question on effeciency

Vernon Gibson
Ranch Hand

Joined: Dec 01, 2000
Posts: 35
I have created a JSP that lists items that are available for purchase. The quantity fields are named using a concatenation of the string "QTY_" and the product number (eg: QTY_03304).
The second part of this process is a JSP that is triggered by the 'Add to cart button'. This JSP receives the quantity fields along with their values and adds them to the cart table using the session id as the key, the 'QTY_nnnnn' string, and the field value.
My question is on retrieval efficiency. Is it better to store the item's description and price on the cart table, or to parse the 'QTY_nnnnnn' values and execute a call to the data bean to retrieve the product records? (i.e. when building a 'view cart' page)
Thanks,
Vernon
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: A Question on effeciency
 
Similar Threads
How many text fields to I need (GWT)?
Problem with a shopping cart application using Stripes
jsp: hidden field problem
Product Details unable to add to shopping cart
Why doesn't exercise 8-1 from Murach's Java Servlets work for me on IE7?