>First, I think this is creating a connection each time you call it. That may be slowing things up a bit. You may try to create a connection object and pass it into this funtion each time.
This didn't change anything. The OleDBAdapter is just slow to fill its data.
>Secondly, as I said previously, instead of passing in a query that gets 1 record at a time 50 times, can you pass one query that gets all records, then loop through the data set.
Yes, this is what I ended up doing. In that particular scenario, it was a practical approach. But, for example, lets say I would have want to do the same thing for the Universal Thread, where about 20 SQL are executed for a login. Hitting a one million record table wouldn't allow me to use such an approach.
>Third, you might want to try to get a data reader rather than a data set.
Can you tell me more about it?
>Finally, you may want to use a ExecuteScaler against and SP to get your single record.
Can you tell me more about this as well?