Different response times...

[ctbny]

I have a VB 2005 program that uses an Access 2000 database that sits on a
network drive. I'm using an oledb connection. From my PC, either through
Visual Studio, or running the app itself, the program can query the database
quickly (maybe a quarter second for a simple INSERT query). If I'm running
the app from another pc on the network, the same INSERT query is taking about
12 seconds. I have tested this same program on multiple PCs with the same
result. Also I installed Visual Studio on one of the 'slow' PCs and the
response time went from 12 seconds down to 3 or 4 seconds, so as I assumed,
it must be a software issue. But I still cannot pin down what particular
piece of software is missing.

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Don't use an OLEDB (ADO) connection. You can connect direct to and .mdb
file using DAO. I'm partial to DAO - various comparison tests done w/
DAO & ADO show that DAO is as fast as or faster than ADO.

A trick that sometimes increases connection speed w/ .mdb files is to
use a short path to the file (DAO).

You could try to find out what connection type the VS is using.... ;-).
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBR5CfV4echKqOuFEgEQLjVQCeMxld4TsPV/PYHekfEtdPzSYQsFQAn2YO
ltguDsM0bxLPTjmSOUIYOfpb
=un3r
-----END PGP SIGNATURE-----