Number of Rowsets....Does it matter?

Hi,

I have an application that consists of more than fifty-four columns. These columns are in different tables that are related via ids. I have two options:

1. Create a large number of rowsets and have each input parameter be the output of a previous rowset, hence, I would have alot of (example):

getSessionBean1().getExpertise_tblRowSet().setObject(1,app_user_tblDataProvider.getValue("EXPID1"));

or

2. Create one rowset that has all the columns I need. However, it should be noted, that, for example when a user logs in...all columns will be returned that I need for different purposes.

Please let me know what you think.

P.S. A combination of the two would really be like option 1 (numerous rowsets)

Thanks.

[791 byte] By [nasheiaa] at [2007-11-26 13:36:23]