Re: Oracle very Slow
From: Ralph (msnews.20.nt_consulting32_at_spamgourmet.com)
Date: 09/15/04
- Next message: Saga: "From DAO to ADO: LastModified"
- Previous message: Saga: "Re: Ado...simple question..."
- In reply to: Lou: "Oracle very Slow"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 15 Sep 2004 13:58:14 -0500
"Lou" <lou.garvin@comcast.net> wrote in message
news:w_WdnSbwr-BE0dXcRVn-pw@comcast.com...
> I am using the Microsoft Data ADODC control bound to the Microsoft
DataGrid.
> I am connecting to an Oracle DB and retrieving about 90,000 records and it
> is
> taking approx. 4 minutes to retrieve them.
>
> I am using Microsoft Active Data Objects 2.7
> Client Side cursor
> type Static
>
> I use a command string
> SELECT * FROM TableName
>
> Somethings very wrong???
>
> -Lou
>
Make sure you are using Oracles latest OLE DB providers for your Oracle
platform.
Then the question becomes - Why do you think something is wrong?. Are you
able to demonstrate faster retrieval in another context?
90,000 records is a 'ton' of records. Depending on what the field data looks
like and the type of formatting you are doing in the DataGrid, the activity
and wide and of your wire, ... I would not expect the process to be
particularly speedy.
My question to you would be - Why do you seriously want to put 90,000
records in a DataGrid? Who is going to scroll thru that mess? Looking for
what? To do what?
While you may be able to speed things up a bit with another provider,
creating your own data aware class or even filling the grid by using ADO
directly - I believe you will be more satisfied if you refactored your
application to use less records and more determinate queries.
-ralph
- Next message: Saga: "From DAO to ADO: LastModified"
- Previous message: Saga: "Re: Ado...simple question..."
- In reply to: Lou: "Oracle very Slow"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
