in reply to speeding up row by row lookup in a large db

If you have to fetch all million cells with individual selects, you're doing it wrong. Either pull out a million row result in one query, or push more of your data reduction to the database using stored procedures.
  • Comment on Re: speeding up row by row lookup in a large db