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/26/04 

Date: Fri, 26 Mar 2004 00:05:10 -0800

Miha,

Thanks a lot for your help.

I found out that problem is at our Oracle Database. It is oracle 8i running
on UNIX. We created a instance of it and put it to a XP machine and my
dataset creating is very fast now.

We still have no clue which parameter we could turn up at UNIX Oracle. But
we have a walkaround.

Thanks for all your help
Mike

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:#N2TDFnEEHA.3748@TK2MSFTNGP11.phx.gbl...
> Hi mike,
>
> That's just weird. I suggest you to try pinpointing the problem.
> IOW look at the differences between healthy macines and those with
problems.
>
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & software development
> miha at rthand com
> www.rthand.com
>
> "mike" <lelehehe@yahoo.com> wrote in message
> news:OxyVBlcEEHA.240@tk2msftngp13.phx.gbl...
> > There are just about 40 records in it.
> >
> > It is not record size related issue. I am using Windows 2000 with
Service
> > pack 3
> >
> >
> > Mike
> >
> >
> > "Miha Markic [MVP C#]" <miha at rthand com> wrote in message
> > news:#hsuabZEEHA.3472@TK2MSFTNGP09.phx.gbl...
> > > Hi mike,
> > >
> > > Ok, so it is design time problem.
> > > How many records are in that table, btw?
> > >
> > > --
> > > Miha Markic [MVP C#] - RightHand .NET consulting & software
development
> > > miha at rthand com
> > > www.rthand.com
> > >
> > > "mike" <lelehehe@yahoo.com> wrote in message
> > > news:%23BuA2JYEEHA.1376@TK2MSFTNGP10.phx.gbl...
> > > > 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: connect to oracle database as sysdba form windows
    ... Is the Unix user in the dba group? ... Is the Oracle server local on Unix but remote from Windows, or vice versa, ... Is the Windows user in the ORA_DBA group if it's local? ... the remote_password_file parameter on the database is the one to look at, ...
    (perl.dbi.users)
  • Re: Block Corruptions on Oracle and UNIX
    ... > filesystems that cause Oracle block corruptions. ... > flavors of UNIX and or Linux. ... block corruption could rear its ugly head when you least expect it, ...
    (comp.databases.oracle.server)
  • Excellent Consultants Available from CESUSA Inc.,
    ... Oracle Apps Distribution, Supply Chain Planning & Manufacturing R11i ... GEO PREF: Prefers West Coast, however, open to all locations in USA ... PL/SQL, Unix Shell scripts, Pro*C ... Software: SAP 3.1, SAP 4.7 ...
    (comp.databases.oracle.marketplace)
  • Excellent Consultants Available from CESUSA Inc.,
    ... Oracle Apps Distribution, Supply Chain Planning & Manufacturing R11i ... GEO PREF: Prefers West Coast, however, open to all locations in USA ... PL/SQL, Unix Shell scripts, Pro*C ... Software: SAP 3.1, SAP 4.7 ...
    (comp.databases.oracle.misc)
  • Re: Story Time
    ... Are you trying to tell me that Oracle was OSS "ported" from Linux to ... OpenVMS as opposed to having been written specifically for VMS? ... release which was only 120 days or so behind the UNIX version. ...
    (comp.os.vms)