>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?