Deploy and compile application code developed in 32 bit, to 64 bit

[philippoommen1]

Hi,

Kindly throw some light on this below issue.

I have a PL , Developed and compiled against 32-bit database . I am trying to deploy that PL with a 64-bit database. It is running fine however it is slow.

Do i have to compile the source code with 64-bit database? Anyother thing I have to look into?

Regards
Philip

 

[TomBascom]

"Databases" are not 32 bits or 64 bits (they might have 64 bit rowids enabled but that isn't really what you're talking about).

The executable that compiles the r-code is what matters.

If you're using prowin32 to compile you don't need to worry -- you will only have 32 bit r-code.

If you are using _progres to compile then you need to be aware of the bitness of that executable because it will create 64 bit or 32 bit r-code depending on what it itself is.

Operating systems are also 32 or 64. But that isn't relevant to Progress r-code.

As for why it is slow... it could be lots of things. The chances are it is something else that is different between the 2 environments that you are comparing. Like PROPATH. Or the db startup params. Or the quality of the hardware.