I'm dynamically generating a form page with data retrieved from a SQL Server and populating the page with checkboxes and textboxes for input updates.
The recordset returned will be small, usually between 10-30 records but because it involves a 3-table join, it's slower than it should be.
Now to my question: Is there a way to keep the recordset around so that I don't have to requery the same recordset? One way I'm told is to put the data in an array that's stored in a session variable and then loop through it to determine any changes. This would work but I hate keeping "things" danggling around in the session object.
Any suggestions? TIA.
It's "my" world. You're just living in it.