Re: TADODataset VERY Slow With MS SQL

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 12/16/03 

Date: Mon, 15 Dec 2003 23:32:26 -0600

> I am trying to preserve at least portions of my old application in
>TTable form to avoid a complete rewrite of the application, which is very
>large and complex. I understand I will have to make changes where I used to
>do setranges and at least some filters but I was hoping to use TADODataset
>with the same table names as my old Delphi 1 tables and keep
>...FieldByName('fieldname')....
>code unchanged where possible.
> As my Provider when I set up my TADOConnection option I am using ->
> 'Microsoft OLE DB Provider for SQL Server'....should I be using some
>other driver which would speed things up?
There is no other provider that will give you any speed improvement. SQL
servers are not designed to preform the kind of sequential access you are
currently doing. If you follow the recommendations in the other replies to your
message you can pick up some speed impalements but for good performance you will
need two rewrite your application to do most of the work with Queries on the
server 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com

Relevant Pages

  • Re: JSH: At the Annals
    ... James has acted honourably in doing a ... > complete rewrite in order to avoid any potential embarrassment to ...
    (sci.math)
  • Re: Can I use ASP.NET Web Admin tool as a part of my site?
    ... I want to have teh Web Admin tool as part of my site but I want to avoid ... having to rewrite all the code to manage my users and roles. ... to incorporate the ASP.NET 2.0 webadmin tool into my site as a link? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Delphi 2008 native?
    ... Cutting yourself off from a lot of functionality, present and future, just to avoid .Net is rather shortsighted. ... just the contrary - the development system is not stable and every ... This keeps coming up, the idea that, if it really were good, then MS would rewrite years worth of perfectly good working Win32 code in .Net just to prove it. ...
    (borland.public.delphi.non-technical)
  • Re: Help! Why is virtusertable messing up my original RCPT address?
    ... I want it to be REWRITTEN so that it arrives addressed to the original ... However, SMTP ... You may of heard of sendmail rewrite rules. ... Naturally the finally destination or any intervening hop servers would ...
    (comp.mail.sendmail)
  • Re: Sql Security ?QL
    ... To avoid this you can rewrite the dynamic code as UDF. ...
    (microsoft.public.sqlserver.security)
Loading