I'm looking for ways to improve the speed of my SQL search and was thinking JavaBeans might do it.
I have had a little look rounf tinternet to see how to do it, only thing is I'm not sure if I can put all of the results into one BEan or if I need to create a new Bean for each line of the results?
Is there a way of creating an array of get/set for one Bean or wil i need to create a new instance of the Bean each time.
JavaBeans won't improve the speed of your SQL. You'll use them to store the db records (usually one bean per record), and arrange them a convenient way for you to retrieve them. For example, using a primary key as the key of a Map.
If the database that you're using allows for indexes creation, then you should probably being using indexes to speed things up. Index the columns that are used in the WHERE clause.
