Re: Speed issue...

Atmapuri wrote:

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

A little bit more info please.

How many fields in the table definition? Which datatypes? Any long
strings or blobs for example? How many records are returned from your
db query? How are you measuring? Is it constantly 4 seconds or only for
the first edit? How fast is it when you repeat the process?

--

.