Re: Speed issue...

Do you have primary key or at least unique index on this table?

//------------------------------------------
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)


"Atmapuri" <janez.makovsek@xxxxxxx> ñîîáùèë/ñîîáùèëà â íîâîñòÿõ ñëåäóþùåå:
news:466fd2bc@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi!

I am using TAdoTable and when I perform:

Table.Edit;
Table['Field'] := Value;
Table.Post;

This takes about 4-5 seconds on a modern PC. It works,
but it is incredibly slow. Is there a way to handle MS Access
database faster?

Or am I doing something completely silly and this should
not be so slow?

Thanks!
Atmapuri



.

Relevant Pages

  • Re: SQL Server very slow over internet...
    ... > to have SQL Server running at their main office and have each client ... > number of records it's incredibly slow. ... > internet it takes so long that I thought something was wrong and gave ...
    (microsoft.public.sqlserver.connect)
  • Re: Developer Edition having issues connecting to server via TCP/IP
    ... connection, but I can't access my files, and the connection seems ... incredibly slow. ... On which machine does the SQL Server you are connecting to run? ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)