Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Tuning SQL Server Load Speed

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.

Additional Info:

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.

4 Replies
flipside
Partner - Specialist II
Partner - Specialist II

Difficult to say without knowing more about the server config.  Here's some initial thoughts ...

Is the Qlikview server running any other applications?

What DB connections are you using (ODBC/OLEDB)?

Are the DSNs configured the same?

Is the Qlikview server behind a firewall?

Is the server running data connection at same time as another process on the SQL box?

Connection pooling issues?

... think that's it for starters !

I would monitor from SQL server side first.

flipside

Not applicable
Author

Answers to the questions posted;

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.

Not applicable
Author

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

danielrozental
Master II
Master II

There is probably some network setting connections messed up in your server, have someone technical check them out.