Your Opinion Needed
Hi, I've come to a fork in the road and I wanted to solicit my programmer community to get some input into my dillema.
Basically I'm creating a data access page to replace an Access database. One record will span multiple "tabs" which I've set up using a MultiView that is controlled by a series of LinkButtons.
My question is this: for maximum performance, which approach is better: Use one dataset for all the fields, spanning all the tabs, or one dataset for each tab.
The way I see it, the former approach will be faster for navigating between tabs, and the latter will be faster for navigating between records (when the user is staying on a single tab). Keep in mind that I'll be caching these datasets, but not until they are actually needed.