Qlik is taking more time when compare to Database. - Qlik Community

viveksingh · ‎2017-04-04

Hi Experts,

I have a SQL that is running fine in the Database but it is taking long time to get the results in Qlik.

Could you please help me with your inputs like what could be the reason for this? and how we can optimize.?

vikasmahajan · ‎2017-04-04

What exactly you are doing ? are you creating qvd and then loading ?

give more insights what exactly you want to achieve.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

viveksingh · ‎2017-04-04

Its a just SQL query with select statement. I'm not creating any QVD

ashok1203 · ‎2017-04-04

Approximately how many records you are fetching from that SQL Query?

AAK

viveksingh · ‎2017-04-04

its about 20,000 records we are fetching.

I want to know what could be the reasons for executing the same query in very slow. even my connection strings are in Good. There were no Special characters in the fields too.

There may be multiple reasons for this. Please post all the possible reasons.

jonathandienst · ‎2017-04-04

>>Please post all the possible reasons.

Its impossible answer a question like that. There could be any number of reasons, from slow network speed to bad model design. It also depends on the type of the database server and its location, the SQL query (view, sp, udf or table), the load script you are using, and so on.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

viveksingh · ‎2017-04-04

Hi,

Thanks for the reply.

Network speed is very good.

There is only one query which we are trying to load. there are no other tables.

stabben23 · ‎2017-04-04

can you show us the SQL Query?