Oracle Odbc Connectivity Very Very Slow 关注
I am running the following:
Windows 7 Enterprise x86, SP1
BarTender Pro 10.1 SR4
Oracle Instant Client 22.214.171.124.0
Oracle ODBC Driver 126.96.36.199.0
I am trying to pull data from a VERY large Oracle R12 ERP system to populate fields in a packing label. My problem is everything from configuring the connectivity to running the SQL query is taking 4 - 5 minutes to complete.
My first step was creating the Windows ODBC connection using the Oracle ODBC driver (listed above) and testing it with a simple query tool. My custom SQL statement returned the needed records in 0.05 seconds.
Things get very painful when I try to configure connectivity inside of Bartender. Here are the steps I use:
File -> New -> Blank Template
File -> Database Connection Setup -> Add -> ODBC Data Source -> System Data Source -> (My DSN)
At this point it sits for 4 - 5 minutes getting the list of tables. Once it completes I select the 3 tables I need add them to the list and then wait another 4 - 5 minutes for that to complete.
Trying to add criteria is impossible. I select the necessary field and when I click the criteria box it'll sit there for another 4 - 5 minutes pulling records until it fails with an "Out of Memory" error and the entire Database Connection Setup window closes. This forces me to start all over again which is VERY FRUSTRATING.
To get around this I have resorted to hand-coded SQL. The query is very simple but it takes BarTender 4 - 5 minutes to actually get the data. This is very puzzeling as I can copy and paste the SQL code into a simple ODBC query tool and it returns the results in 0.05 seconds. (Yes, I timed it)
What the crap am I doing wrong?