title: Calling Oracle SP with TableAdapter very slow
body: <p>I have a query that runs super fast when executed in the sql editor (oracle): 1ms.</p>
  
  <p>The same query (as stored procedure) when executed by a DataSet-TableAdapter takes 2 seconds. I'm just retrieving 20rows.</p>
  
  <p>Since I'm using a TableAdapter, the return values are stored in a ref cursor.</p>
  
  <p>If I was fetching 2'000 rows I could understand that some time is needed to build the DataSet, but 2 seconds for only 20 rows seems too much for me.</p>
  
  <p>There is a better way to execute SP on oracle or this is the only way?
  What could I try to do to improve the performances?</p>
  
  <p>Thanks for your help!</p>
  
  <hr>
  
  <p>Searching in google, it seems that the problem is with the refcursor. Others people faced the same performance issue, but no solution is provided.</p>