[AccessD] ..Performance ADO - DAO ..

Hi Marcel

Thank you.

What would the figures bee for not keeping the connection open?
I'm not sure that would add much to the figures even for the 10 Mb
network ...

/gustav


> Just to let you know. Turning of the subdatasheets and keeping the
> connection open shows the following figure.

> 10MB network (both tables contain about 15.000 records)
>      Reading a customertable       was 10 seconds  now 3 seconds
>      Reading a order table               was 7 seconds       now 2 seconds

> 100 MB network (both tables contain about 15.000 records)
>      Reading a customertable       was 3 seconds        now 1 seconds
>      Reading a order table               was 2 seconds       now 1 seconds