performance slow down on XP

[Jim]

Hello,

I use a Delphi application that communicates to Access 97
DB via jet 3.0.

The DB resides on a Win2k server.

When the application is launched on a Win98 machine, all
is well. (good performance opening and closing tables,
joins, selects ...)

When I launch the same application on a XPpro machine, I
get very very slow performance times. (in some cases, 10
times slower)

all the machines are up-to-date patched by winupdate.
I tried disabling opportunistic locking on the server.
- no improvement.

can anyone help ?


thank you very much.


Jim.

 

[Van T. Dinh]

If it is an A97 file format, I think you should use JET 3.5 rather than 3.0
since 3.0 is for Access 95. If you use DAO to access the data then you
should use DAO 3.51.

Patching by windowsupdate probably won't make any difference as JET 3.5 /
DAO 3.51 are not included in windowsupdate AFAIK.

Sorry, don't know the solution, though.

 

[Tony Toews]

I use a Delphi application that communicates to Access 97
DB via jet 3.0.

I'd agree with Van on using Jet 3.51. I'm quite surprised that you
can actually use Jet 3.0.

The DB resides on a Win2k server.

When the application is launched on a Win98 machine, all
is well. (good performance opening and closing tables,
joins, selects ...)

When I launch the same application on a XPpro machine, I
get very very slow performance times. (in some cases, 10
times slower)

I'd suggest the standard keeping a recordset open at all times concept
and see if that helps. See the Access Performance FAQ at my website
although you'll have to adapt it to Delphi. Some of those items
won't apply to you as they're only A2000 and newer.

all the machines are up-to-date patched by winupdate.
I tried disabling opportunistic locking on the server.

OpLocks is more for corruption.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm