Re: Generate DataSet is extremely slow for OleDbDataAdapter (with Oracle 8i Client installed)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: mike (lelehehe_at_yahoo.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 01:32:28 -0800

Hi Miha,

It is very simple to dupliate this problem on my machine:

0. Create a OleDBProvider for Oracle connection
1. New a C# Winform
2. Drag "OleDbDataAdapter" to the form, and in the query use "Select * from
MyTable"
3. Then create the adapter is about 40 seconds.
4. Create a DataSet is about 2-3 minutes.

We have another machine with same problem.

Mike

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:ed6u4QXEEHA.2460@TK2MSFTNGP12.phx.gbl...
> Hi mike,
>
> "mike" <lelehehe@yahoo.com> wrote in message
> news:e1btQ4WEEHA.3404@TK2MSFTNGP10.phx.gbl...
> > Hi ADO Guru,
> >
> > I have a problem when I use OleDbDataAdapter and try to generate DataSet
> for
> > Oracle. It is extremely slow.
> >
> >
> > my environmnet:
> > VS.NET 2003, Oracle client 8i, OleDbDataAdapter, WinForm(C#)
> >
> > Creating a new OleDbDataAdapter is always about 40 seconds.
>
> 40s? There is something horribly wrong.
> What is your code?
>
>
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & software development
> miha at rthand com
> www.rthand.com
>
> Creating a
> > DataSet is much slower and the speed is depend on how many DataSets I
> > already have.
> > For example, if I have 5 DataSet in the WinForm, to create the 6th would
> > cost me 6 X 3 minutes = 20 minutes. Then I could see the last dialog in
> the
> > "Generate Dataset Wizard".
> >
> > I also tried Oracle client 9i on my machine and I got the same problem.
> >
> > Our Oracle database is healthy. The problem is in my development
machine.
> >
> > Any suggestion?
> >
> >
>
>

Relevant Pages

  • Re: Scope, Schedule and Budget.
    ... "Mike Glen" wrote: ... > (tasks, precedences, durations, resource details, resource calendars, ... or will be entered into an Oracle accounting ... >> and actual cost budgets. ...
    (microsoft.public.project)
  • Re: DBD::oracle DBD::ODBC DBI
    ... Tofigh, Mike wrote: ... Perl 5.8, in Solaris 8, running with ORACLE 9i ... The instant client libraries can be installed very easily and can be used independently of Oracle database itself. ...
    (perl.dbi.users)
  • Re: datareader reader questions
    ... where this field is a number in Oracle ... Mike ... >>I am trying to use a datareader to retrieve data and set some properties. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Generate DataSet is extremely slow for OleDbDataAdapter (with Oracle 8i Client installed)
    ... I found out that problem is at our Oracle Database. ... We still have no clue which parameter we could turn up at UNIX Oracle. ... > Hi mike, ...
    (microsoft.public.dotnet.framework.adonet)
  • NullReferenceException calling OracleConnection.Open()
    ... to open an oracle connection result in an error "The timeout period elapsed ... because all pooled connections were in use and max pool size was reached". ... It seems this can happen at any time and is not related to the server being ...
    (microsoft.public.dotnet.framework.adonet)