I have a script to load from a large SQL Server table 7+ million rows. The extract takes 15 minutes from my desktop, but when I run the extract on the qlikview server it takes 3 hours. Does anyone have any ideas.
Qlikview is the only application running with no other DBs on the server (e.g. Oracle or DB2). The script runs fine on my laptop so I don't believe that SQL Server itself is the problem. At the time of the script run, it was the only connection on the server. I was hoping that there is a setting on the ODBC connection or OLE on the Qlikview server that is causing this delay.
No - Qlikview is not running any other applications including another database (e.g. Oracle, DB2)
Qlikview is behind the firewall with the database, also my laptop which is also behind the firewall runs fine.
There aren't any other connections running at the time that I ran the script. No sure about connection pooling, will follow-up with the DBA group, I think SQL Server is fine because the script on my laptop runs in a good time.
Qlikview is the only application running on the server. There aren't other database connections (e.g. Oracle or DB2) on the server. I think SQL Server is fine because the script on my laptop runs fine (15 minutes). The connection was the only one runnning at that time so I don't believe connection pooling is an issue