Re: OleDbCommand.ExecuteReader Performance

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Elad (Elad_at_discussions.microsoft.com)
Date: 01/20/05 

Date: Thu, 20 Jan 2005 06:45:03 -0800

Hi, thanks for your reply.

I'm referring to a very simple configuration of a client application
connecting to a server that is placed in another country. The OleDbCommand
object is created on the client and the query is sent to the server over the
web.

The client is not a web-based application (which is probably what you were
referring to).

"Sahil Malik" wrote:

> Okay --- even in a web based environment, your server is what holds the
> OleDbCommand instance, which is not communicating over HTTP to the
> underlying database. So it's only as bad as the connection between your web
> server and your oledb database is.
>
> To get chunks of data instead - you can use DataTable/Dataset.
>
>
> - Sahil Malik
> http://dotnetjunkies.com/weblog/sahilmalik
>
>
>
>
> "Elad" <Elad@discussions.microsoft.com> wrote in message
> news:84ECAA3A-27E3-4788-8C1E-E172D7C8A821@microsoft.com...
> > Hi,
> > I have a question regarding OleDbCommand.ExecuteReader.
> >
> > From what I understand, ExecuteReader fetches rows on demand, on a row by
> > row basis.
> >
> > What are the implications of using this method when your database is
> > accessed over the web? Won't it be terrible slow? The reason I ask this
> > is
> > because it seems that each time I call OleDbDataReader.Read(), an HTTP
> > request is sent to the server and one row of data is returned.
> >
> > Is there a better way of receiving user-defined chunks of data from
> > databases? I would rather not use OleDbDataAdapter as it is too slow.
> >
> > Thanks.
>
>
>

Relevant Pages

  • Re: Help with first VB application - Data Entry form
    ... I assumed a desktop / winform client application ... time' stamp from the database machine - control machine ... ... problem solved - web server is control system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Help with first VB application - Data Entry form
    ... I assumed a desktop / winform client application ... time' stamp from the database machine - control machine ... ... problem solved - web server is control system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Remobjects v KBM
    ... >> client query components) follow from that. ... Then, connections can be created to say SQL Server, Oracle, Interbase and ... can then be created from the abstract dataset definition in 'customers' to ... implicitly - this makes your code not be database connection specific). ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Help with first VB application - Data Entry form
    ... stamp from the database machine - control machine ... ... unnecessary data to the client ... ... and when building a database independent UI / Client - Server application, ... JavaScript, for example) and thus, will get the time from the web server, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Opinions needed about the best "Middleware suite" kbmMW vs. RODA
    ... kbmMW supports cross db in such way that all you need to do in your application is to set one property to switch to ... What one have to concentrate about is minimizing the amount of data moved from the app server to the client. ... C/S setup's usually have a quite active chatter going on between the client and the database, ...
    (borland.public.delphi.thirdpartytools.general)