Re: Which way will give me better performance?
Thursday, July 12, 2001 11:56 PM
The second solution is better because you separe the business layer to the jdbc layer. An other reason is that the application is safetly. Think about the ResultSet and the Statement objects ... wath happen to the ResultSet when the connection is closed? What happen to the ResultSet when you execute an other SQL query with the same Statement? And so on...
I will suggest you to put each object in a LinkedList, that is a Collection as the Vector class but much better for save a big number or Object. With a LinkedList object you can do the same:
ListIteretor iter = linkedListoObject.listIterator();
and than you can iterate through your object ...
That is a good solution.
Bye bye and for other problems I'm ever here, Aron