ODBC-64 bit will improve the performance?

[philippoommen1]

Hi,

Our Progress application has an interface with AutoCAD via a VB interface application. Here we are using ODBC-32 bit and Progress Database 32-bit. AutoCAD also 32-bit. OS is WIN-7 64 bit . This setup is working fine with out any performance issue.

However rencently one of our customers start using AutoCAD software - 64 bit. It creates a severe perforance issue. While read/write date to Progress DB.

To ressolve the issue we need some clarrifications. Kindly valrify the doubts.

1. If we change Progress 32-bit DB to 64-bit db will improve the performance?
2. If we change 32-bit ODBC to 64-bit will imrove the performance?
3. Or the problem is with VB code ? Do we have to rewrite the application .Net?

Now our test environment all the applications in a single PC. If we need to run a 64-bit ODBC in that PC how can I do that? because what I understood odbc-64 bit available only with Progress DB 64-bit. So if my db is remotely running and Progress application (32-bit Progress) is also connected with that 64-bit DB then how can I acess the 64-bit ODBC from that remote server. Is there any client license shold install in the application running PC? Please give some idea how that archtesure will work?
TIA
Philip P Oommen

 

[jdpjamesp]

If the OS the server is running on is 64bit then the database should also be 64bit. I've no idea about the ODBC stuff I'm afraid, but server and database should match.

 

[RealHeavyDude]

You don't reveal anything about the Progress/OpenEdge version you are using an what OS this is running on. Usually server operating systems nowadays are 64Bit. Running the database in a 32Bit emulation just does not make any sense - you should run the database 64Bit on a 64Bit OS anyways.

AFAIK, the first release where Progress introduced 64Bit ODBC drivers on some selected OS platforms was OpenEdge some 10.1B service pack. Depending on the Progress/OpenEdge combination you are running you need to upgrade for a 64Bit ODBC driver to be available to you.

I can't tell anything about the performance differences in the driver, though I suspect just switching the bitness does not enhance performance unless the software from which you use the driver does.

Heavy Regards, RealHeavyDude.