Re: msSQL and ado performance

From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 19:50:41 +0300

It depends on what you want to do. Will you do more selects or more
insert/change/delete operations? Do you use data-aware controls or process
data without visualization?

As one of the steps you should optimize your database - determnine
table/columns metadata, add indexes etc.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Marko Lahtinen" <marko.lahtinen@rem.filmtown.fi> сообщил/сообщила в
новостях следующее: news:41a4a0d6@newsgroups.borland.com...
> 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: OOP in database programming - Newbie question
    ... > change database vendors with minimum fuss. ... Certainly data modules help in separation, but many people just put the data ... > Tell me why data-aware controls limit one to a single user system that can ... TeamBUG support for UK-BUG ...
    (borland.public.delphi.non-technical)
  • Re: OOP in database programming - Newbie question
    ... "Joanna Carter " wrote ... If one uses ADO with OLE DB providers you can ... >> change database vendors with minimum fuss. ... > Data-aware controls are only bad if they are connected directly to database ...
    (borland.public.delphi.non-technical)
  • Re: How do you create a data access layer?
    ... > I've read that you really should have a abstracted data layer, ... > decouple database accesses from the rest of your code. ... There are at least two good reasons for decoupling database access from the ... It may be connected to data-aware controls and report ...
    (comp.lang.pascal.delphi.misc)
  • Re: Read (and Visualize) Database Schema
    ... Words to the wise, Christian wrote: ... schema and/or visualizing it) are welcome! ... Database Exploration Using Multidimensional Visualization" ...
    (comp.lang.java.gui)
  • Re: OOP in database programming - Newbie question
    ... > your forms to one particular type of database and all the logic that reponds ... > to data changes ends up being written on the forms and means that, ... Tell me why data-aware controls limit one to a single user system that can never ...
    (borland.public.delphi.non-technical)