I'm using ADO. I have a few different tables that I join together in a query. I then use the data on an Active Server Page.
I'm not sure what is better to do...
I have a page that needs to open certain information each time. Then I need info from other fields only during certain situations. Right now my query gets all the fields that I might possibly need.
So now...should I just do one select statement and return all the fields (about 25). Or should I just get the 15 or so I need, then when I need other fields do another select statement and get the info that I need again? I might have to change select statements about 6 times...or only 2 sometimes...just wondering what's best? Or maybe should I even have the 6 different queries for each and then open those?
Thanks