Why do my Delphi (using Pervasive PDAC VCL) applications run 100x slower performing database function (Relational or Transactional) on a Win7 64bit computer, than a Win7 32bit?
Posted on 2014-07-24
I have several applications that I've built for my company over the years. Just in the past year, we've refreshed all of our computers, and now everyone (there are a few WinXP computers that have no access to internet so I left them in play) has a new desktop running at least Windows 7 Pro (64bit). Well, I've also migrated my applications to the newest (that PDAC supports..that's Pervasive Database Component Library for Delphi) Delphi (currently for me, it's XE5). I have one laptop that is running Windows 7 which is a 32bit computer. It performs the database functions of my applications just as fast as it should, just like the XP computers (all 32bit). However, on any of my other computers running WIndows 7 Pro, 64bit, it takes 100x as long to perform these same functions of these programs. It has to do with the PDAC. I'm sure of it, but I don't know what to do to fix this. Apparently Pervasive (Actian) does have 64bit compiled "runtime" PDAC libraries, but I don't know how to deploy them, as the PDAC is normally a design time component library (as well as it's runtime library files). Only the 32bit versions have a visual component. I thought it was a Stringgrid issue, but I've realized since, that this happens on ANY database process.
We are running Windows Server 2008 R2 Enterprise, with Pervasive SQL v11.3 (all latest patches in place on server and clients). All workstations have at least 8GB of RAM, running WIndows 7 Pro 64bit (except the ones I mentioned earlier). My specific development environment that I'm trying to work in currently is Delphi XE5 (but I have 7, XE, & XE2 installed on my old Win XP computer..which I'm slowly phasing out of use).
Any help is greatly appreciated!