title: Data Transferring is Slow – from Backend to Front-End
body: <p>==> <strong>My System</strong> :</p>
  
  <p>Processer - <code>Xeon 8 Cores @ 3.8GHz</code></p>
  
  <p>RAM -<code>20 GB</code></p>
  
  <p>Storage – <code>11 HDD SAN - RAID 5 configured I/O Rate – 260 MB/s</code></p>
  
  <p>Network – <code>Cisco 1 Gbps Intranet</code></p>
  
  <p>Front End – <code>Using C#.Net desktop Application, PL/SQL Developer (write PL/SQL)</code></p>
  
  <p>==> <strong>Database</strong> :</p>
  
  <p><code>Oracle 11g</code> (11.2.0.3) Standard Edition on <code>Windows Server 2008 R2 64bit</code> (OLTP use)</p>
  
  <p>Have more than 60 tables.</p>
  
  <p>Most tables have above 8 million records</p>
  
  <p>Reports are generated which output gives approx. 5 millions records and send to front end.</p>
  
  <p>==> <strong>My Problem</strong> :</p>
  
  <p>Data fetched and processed on complex query is good enough.</p>
  
  <p>But when procedure or query execute which output may have millions of data</p>
  
  <p>Sending to front end or pl/sql developer(test procedure/query)</p>
  
  <p>My problem starts here,</p>
  
  <p>Oracle database processed data (no high cpu or hdd usage on server side)</p>
  
  <p>Network usage show <code>2-3 MB per second</code> transfer rate</p>
  
  <p>Data starts coming into Client side slow like <code>800 records</code> in 1 second.</p>
  
  <p>Its millions of data to come, so taking too much time to complete data arrive on front end.</p>
  
  <p>So management is not happy with this, its report on front side taking minutes to display.</p>
  
  <p>How can I improve this? I need faster data on Client side.</p>