Re: This seems slow...Why???

From: Miha Markic [MVP C#] (miha)
Date: 03/02/04 

Date: Tue, 2 Mar 2004 09:13:29 +0100

Hi Bob,

Are you sure that Fill method is slow?
Is your table bound to a control or controls? 

-- 
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com
"Bob McCormick" <anonymous@discussions.microsoft.com> wrote in message
news:F4712A07-32A9-4B37-95CF-006584B31445@microsoft.com...
> Hi All,
>
> I'm just coming up to speed here on .NET and have a C# WinForm App that
accesses a database. I've gotta form with the following code in the
form_load event:
>
> private void DocumentsDetail_Load(object sender, System.EventArgs e)
> {
> this.dsDocuments1.Clear();
> this.daDocuments.Fill(this.dsDocuments1.Documents_Sel);
> }
>
> The DataAdapter is using Stored Procedures and I'm seeing dismal
performance on my local development machine.  To bring the form up _without_
the above code, it displays in under 1 second.  Add the above code and it
takes a little over 4 seconds to bring it all up with the data being
displayed.
>
> This particular stored procedure is simply a 'Select * from Documents'.
Table only contains 3 records and should not have more than 150 records, so
not worried about the star.  Number of columns is around 15 or so.
>
> Machine isn't latest and greatest, but certainly not a dog either.
>
> Is this a typical response time and so should just get used to this, or
more a pilot error?  Appreciate any comments on this - this just really
seems very slow to me and I'm concerned.
>
> Thanks...Bob
>
>

Relevant Pages

  • datagrid control & stored procedures - how to use together
    ... I'm using all stored procedures, necessarily, and am having quite a bit of ... The control apparently presumes access directly to tables, ... but my environment requires -all- access to the db to be abstracted through ... vb.net - and using stored procs /TDS to select from and update the db? ...
    (microsoft.public.vb.database)
  • Re: SP Source Control Options
    ... > relies heavily on Stored Procedures on SQL 7. ... > What options are there to implementing Source Control on ... Script them out of SQL Server, ... control system. ...
    (microsoft.public.sqlserver.security)
  • Re: SP Source Control Options
    ... > relies heavily on Stored Procedures on SQL 7. ... > What options are there to implementing Source Control on ... Script them out of SQL Server, ... control system. ...
    (microsoft.public.sqlserver.security)
  • RE: Prevent direct connections
    ... If this is not possible then you can apply some control by denying direct access to user tables and only allowing it through stored procedures. ... Mark Allison, SQL Server MVP ...
    (microsoft.public.sqlserver.security)