msSQL and ado performance

From: Marko Lahtinen (marko.lahtinen_at_rem.filmtown.fi)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 16:55:42 +0200

Hello!

I'm creating a application connecting to MsSQL-server using ado-components
(ADOConnection and ADOQuery). The database is in the same machine as the
application. I need fast performance, so can someone give me an example of
some basic setups in Connection and Query components ? What things I need to
consider ?

Thanks!

Marko

Relevant Pages

  • Re: Connect to Access Data from various regional locations
    ... All users will be connecting via broadband. ... When using MSDE ... > Dim rf As DAO.Recordset ... > There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.externaldata)
  • Re: Connect to Access Data from various regional locations
    ... All users will be connecting via broadband. ... When using MSDE ... > Dim rf As DAO.Recordset ... > There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.dataaccess.pages)
  • RE: Problem with connecting to an Oracle database using Perl
    ... Problem with connecting to an Oracle database using Perl ... *IS* described in the DBD::Oracle perldocs - as the perldocs are included ... I do not have a problem connecting to the remote database using the Oracle ...
    (perl.dbi.users)
  • Re: Running SQL script through VB
    ... I am connecting through a default username and my ... The error I am getting while running a script (generated by SQL server ... "A use database statement is not allowed in a procedure or trigger" ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Compact Framework 2.0 to Sql Server 2000 -- cant Open() connectio
    ... I tried connecting to a different data source on another machine: ... datasource, again using a \IERP to get to the correct database, and it failed. ... > I have XP SP 2 on the machine w/ the sql server, ...
    (microsoft.public.dotnet.framework.compactframework)