title: Fetching records from database
body: <p>In my C# 3.5 application,code performs following steps:</p>
  
  <p>1.Loop through a collection[of length 10]</p>
  
  <p>2.For each item in step 1, fetch records from oracle database by executing a stored proc[here,record count is typically 100]</p>
  
  <p>3.Process items fetched in step 2.</p>
  
  <p>4.Go to next item in step 1.</p>
  
  <p>My question here, with regard to performance, is it a good idea to fetch all items in step #2[ie. 10 * 100=1000 records] in one shot rather than connecting to database in each step and retrieving the 10 records?</p>
  
  <p>Thanks.</p>