RE: performance issues(OracleDataReader & Adapter)

From: Techstudent (Techstudent_at_discussions.microsoft.com)
Date: 10/11/04 

Date: Mon, 11 Oct 2004 14:59:02 -0700

Please ignore this post, by mistake my oracle hint was missing in the query
used in the application which was the cause for the bad performance.

Thanks

"Techstudent" wrote:

> I am trying to populate grid using OracleDataReader and it seems
> Datareader.Read() is taking alot more time in reading the resultset(around 12
> seconds in reading 50 records).
> the same sql statement in SQL plus is taking less than 2 seconds.
>
> I tried using sqldataadapter.Fill but this is also taking a lot more time
> than expected.
>
> If any one has any suggestions to improve the performance can you please let
> me know.
>
> Thanks
>
>
>

Relevant Pages

  • Re: SQL Where clause problem?
    ... > Ok I must be missing something very simple here as I've never run into ... > it re-arranges the bracket sets making the OR's behave differently... ... > SQL STATEMENT BEGIN ... I've tried running this query through ASP as well as the ...
    (microsoft.public.sqlserver.programming)
  • Re: Combo Box Problem
    ... if so, what's missing? ... getting an error message, and if so, what? ... a SQL statement? ... if it's a query or SQL ...
    (microsoft.public.access.gettingstarted)
  • RE: Help with Graph
    ... Here is my SQL statement to see if I am missing something: ... In the query you want to add the table with all dates ... > interpert this as a zero. ...
    (microsoft.public.access.reports)
  • Re: Multiple Criteria Form problem
    ... You're missing the WHERE statement: ... The easiest way to create an sql statement is to build a query and then ...
    (microsoft.public.access.forms)
  • Re: Code not working... Please Help!
    ... I actually started reading about it. ... > You can create the SQL statement by concatenating pieces in your code, ... > can put it into a query design window, you can open a recordset object. ...
    (microsoft.public.access.reports)