Switching from 32bit to 64bit version

The terms 32-bit and 64-bit refer to the way a computer's processor (also called a CPU), handles information. The 64-bit version handles large amounts of random access memory (RAM) more effectively than a 32-bit version.

The important thing to understand that the 32-bit version uses 32-bit version drivers and it cannot use 64-bit drivers. Same apply for the 64-bit version. Before installing the 64-bit version you have to make sure that relevant 64-bit drivers, ODBC Drivers, OleDB Providers and Clients are installed.

For example to make sure that 64-bit version works with Oracle Database you would need to install the 64-bit version of Oracle Client

During our tests, the performance of 64-bit version was very similar to 32 bit.

If you are:

  • Using a lot of memory
  • Sorting large amounts of data
  • Creating and reading very large QVD files.
  • Working with large Lookup transformations

Use the 32-bit version, It is easier to install and configure

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETl forum

  • knowledgebase/switchingfrom32bitto64bitversion.txt
  • Last modified: 17/09/2018 09:44
  • by admin