I’m running Visual Importer ETl Pro. I recently finished development of some Visual Importer jobs on a development machine. I moved these jobs to our test box to test them out. Outside of hardware, the environment is the same.
The problem I’m having is the following:
When I run a job in my development environment, it takes approximately 5 minutes to update/import 28,000 rows. However, when I do it out my test environment, it takes 26 minutes. BIG DIFFERENCE.
Test environment is a more powerful environment than my development environment. The source for both development and test is the same (a FoxPro DB). Target Databases and Visual Importer runs out of the same box on both development and test.
Question is: Is there anything I can look at on Visual Importer to see what is causing the performance difference? I’m a little confused being that test has better/faster hardware, but yet is running A LOT slower.
Your help would be greatly appreciated.
Thank you.
Todd
