Testing our VB6-based database application under Vista (Business Pro, Release version, Clean install on fresh partition), all seems largely well with one very noticeable exception: Multiuser Jet 4.0 database access is vastly decreased (often involving several minute waits for simple queries that generally run in one or two seconds); on the other hand, single user access seems quite comparable to its former speed, as does general file system/file server performance.
Is this a known issue with Jet 4.0 under Vista Can anyone suggest any potential workarounds or know of any factors which might be responsible for the performance hit
-Pete
Vastly decreased multiuser Jet DB Performance under Vista
Hot Topic
- LocalService implemented in RemoteSrvice Ok?
- Can't debug workflow when workflow assembly is loaded directly into memory
- What is the best way to clean install my hard drive
- value of MSGFLT_ADD/MSGFLT_REMOVE
- Application Opens By Itelf Fine, But When Opened With Process it fails to load components
- Listener activity in Sequncial Workflow in asp.net?
- The Windows SDK for Windows Vista is available for download
- Protected Registry key access under Vista.
- Exception handling in ExternalDataExchange services
- Custom activity with dynamic properties sample
Windows Vista
- how can i use anonymous pipe in vista? i can't pass the handle through createprocess..
- Executing the workflow under a custom permission set
- Creating a sharepoint workflow
- Comments, Suggestions, Features and WHAT THE HECK WAS THAT!?
- WCF and Cardspace sample without IIS?
- Databinding Support
- some problem with sideshow?????
- Vista RTM software compatibility list
- how to customize icons shown in the designer
- Both GetSystemMetrics(SM_CXSIZE) and GetTitleBarInfo returns wrong values for Vista Aero
Vastly decreased multiuser Jet DB Performance under Vista
janthonyb1
Testing:
- Single user access (database stored either locally or on the file server) yields acceptable performance
- Multi-user access with the database stored locally, and multiple instances of the application running against it simultaneously, also yields acceptable performance.
- Multi-user access, with the database stored on the file server, yields very poor performance.
A manifest file is included with the program, purely to force it to run with the version 6.0.0 Common Controls.
-Pete
Tru_Messiah
Since it is not a known issue, your best recourse is to use your Microsoft Partner Support benefits and report this in an incident (as opposed to advisory). If it is confirmed to be a bug, then it would not be decremented against available incidents.
If you are not currently a Microsoft Partner, please see the following link:
http://www.microsoft.com/presspass/press/2005/apr05/04-12ISVAdvisoryPR.mspx
HSBF Lewe
Wow, I haven't seen or heard about such an issue. Be interested in knowing more about it if true.
What have you tried to do to isolate the problem
I suppose what I'm getting at is trying to figure out whether this is a Jet problem or a problem with the way Jet uses network shares on Vista.
What kind of application compatability is in effect for your program Does it have an Application Manifest that specifies the required execution level
pompom
The server isn't virtualized at all--it's just a bog-standard file share situation.
-Pete
Pr09aN1g0d
More fishing...
Is there a performance problem when only doing simple SELECT queries or is it fine until you update What CursorType and other parameters are you using
I'm thinking it's locking related, of course. I assume you're holding connected Recordsets for extended periods of time. Does your client multiplex activity over a single connection or leave multiple Connections and Recordsets open (yes, two different issues). I'm thinking ADO here but DAO or ADO.Net will have a lot in common anyway.
If ADO have you considered turning on row-level locking Then again you might still be locking up lots of rows, depends on what you're doing.
Sorry, I'm probably barking up the wrong tree.
NozFx
HedleySohn
R.X.
-Pete
kennm