Re: speed isssues with ADO and access 2000 database

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 12/01/04 

Date: Tue, 30 Nov 2004 21:25:38 -0600

>My programmer developed my software using boreland builder 6 with ado querie components. I find queries that are performed on my microsoft access 2000 database takes a very long time to come up with results Iam looking for. Is there a way to speed up queries when using ADO with access 2000

Are you actually comparing the execution from your Delphi program to something?
Its possible that your application was poorly programmed and improvements in
programming could give you greater speed. 

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

Relevant Pages

  • Are there any INTRINSIC advantages of the C# language over VB.NET?
    ... in comparing the two all of the advantages that I have come ... execution falls into the next case; this substantially ... When you have a series of terminating braces in C#, ... Can anyone come up with advantages of the C# language ...
    (microsoft.public.dotnet.general)
  • Re: cxx performance
    ... > Yes, the real performance lies in execution, but when executing the TDD ... > grand total of much lost productivity over a day. ... I assume that you are being sarcastic about comparing ... > me - I was looking for ways to speed up the compilation in the current ...
    (comp.os.vms)
  • Re: Efficiency of is null vs nullif
    ... I am comparing two fields in a table to check if they are not equal.This can ... col2 is not null) or ) ... The qeury execution plan is same for both ... >> either by using is null or nullif function. ...
    (microsoft.public.sqlserver.programming)
  • Re: circles
    ... I wasn't trying to offend your execution time... ... Just comparing. ... subroutines are, the faster they execute. ... and compare the time of 100 loops of your code ...
    (comp.sys.apple2.programmer)