topic Re: Performance Issue in QlikView

Performance Issue

spsrk_84 — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I am facing a issue w.r.t data loads through publisher.Till last week the Data loads use to happen very fastly i.e 1 million rows of data hardly takes 2-3 mins.All of a sudden i dont know what has happened the loads time increased to 23 mins for the same 1 Million rows of data. I have checked with the nwtworking guys is there any problem from their end.Manually if i copy the files from QV server to my local the speed is too good (up to 2 MBPS).

The reason i am posting this issue is to know is there any configurations do we need to check in this kind of scenario's or if you have suggestion to be followed to reslove this issue.

Please give ur inputs/suggestions.

Regards,

Shiva

Re: Performance Issue

Miguel_Angel_Baeyens — Mon, 15 Oct 2012 12:55:12 GMT

Hi Shiva,

If you have not upgraded the OS or done any other change in the computer and software, the first try I'd do is log on to the Server as the QlikView services account, then open Desktop and do a manual reload of the script just in case all paths and drives are properly set, and permissions as well.

Is there any chance that the process is running along with any other intensive usage process such as backups, antivirus scans, or so?

By the way, once the document reloads, does it work fine (objects rendering, calculations, change of sheets) or it performs poorer than before?

Hope that helps.

Miguel

Re: Performance Issue

spsrk_84 — Mon, 15 Oct 2012 13:11:19 GMT

Hi Miguel,

I am facing the issue during the initial loads process from DB to Qvd.Later on everything is working fine.

Regards,

Shiva

Re: Performance Issue

Miguel_Angel_Baeyens — Mon, 15 Oct 2012 13:21:50 GMT

Hi,

Does the process work fine when the reload is done by the Desktop instead of the Server? Any differences?

Miguel

Re: Performance Issue

spsrk_84 — Mon, 15 Oct 2012 14:28:20 GMT

Hi,

Both the ways(Through QV Publisher & Desktop ) i am facing the same performance issue.

Re: Performance Issue

Miguel_Angel_Baeyens — Mon, 15 Oct 2012 14:40:13 GMT

Hi,

Is is possible that some changes had happened to the database or the driver? What if you run one of the SQL statements in your script through a query analyzer or any similar tool that allows you to perform SQL queries to your data? Do they run as slow as they do with QlikView?

Miguel

Re: Performance Issue

spsrk_84 — Mon, 15 Oct 2012 15:33:56 GMT

Hi,

No Changes were done neither to database or the drivers.I ran simple select query from Qlikview server it took the same time similar to job through the publisher.

Regards,

Shiva

Re: Performance Issue

Miguel_Angel_Baeyens — Mon, 15 Oct 2012 15:39:53 GMT

Shiva,

What if you do that same SQL SELECT within the data source query analyzer? Does it take the same time or does it run faster?

I still don't see how is this related to QlikView Server... (not saying it's not because QlikView, but that it's difficult to see where is the issue).

Miguel

Re: Performance Issue

StefanBackstrand — Sat, 14 Sep 2013 20:22:21 GMT

Except for the excellent advise from Miguel, I would reference to the script log files (which is called DocumentLog.txt and will be stored next to the task log on the Publisher machine (or wherever the Distribution Service application data folder is located)), to see where in the script the difference is - basically, what part is taking more time now than it did before? Is it the connection to the database (driver, network)? The fetch of data (network, database performance)? Script execution or data transformation on the QDS node (performance, data amount drastically changed) and so on. Find the difference.

You can read the script log file with QlikView to visually find differences in large script files.

/edit: Saw now that this was over a year old, I wonder why it showed up in my feed just now.. ?

Re: Performance Issue

Fri, 22 Sep 2017 21:33:34 GMT

Currently suffering this exact same issue QV11 publisher server running fine up until yesterday now a job that used to run in 20 mins takes hours via the QMC but run the QVW manually on the server it runs in 20 mins as expected. Pulling from SQL 2016 but been that way for months nothing changed on either servers. Was a root / fix ever found to this?

Re: Performance Issue

markdur101 — Thu, 27 Dec 2018 14:15:36 GMT

I am having the same problem. Was this ever fixed?

Re: Performance Issue

Mr_H_Huang — Thu, 09 Dec 2021 15:40:36 GMT

I have the same issue but I luckily found a solution. I hope anyone met the same issue can be benefited from this solution. I have changed a syntax for my database Connection from "OLEDB CONNECT TO [Provider=SQLOLEDB..." to "OLEDB CONNECT32 TO [Provider=SQLOLEDB..." then it works as fast as before. Just forcing the QlikView to connect the database in 32 bit then it works fast and back to normal.