Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Why does it sometimes take extremely long before showing the 1st calculation after the connected?ipt

Qlikquestion.png

2 Replies
oknotsen
Honored Contributor III

Re: Why does it sometimes take extremely long before showing the 1st calculation after the connected?ipt

  • Slow connection time with your database.
  • Your PC is busy.
  • Slow or varying hard disk access.

... just to name a few options.


May you live in interesting times!
luciancotea
Valued Contributor

Re: Why does it sometimes take extremely long before showing the 1st calculation after the connected?ipt

Depending on your query, the database performs a series of steps in order to fetch the output rows. QlikView is just passing the query and then waits for the result.

If it's a production database, there might be other processes that are blocking your query.

So, try to optimize the database performance. If that's not enough, maybe you should use incremental loading.

Community Browser