Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.?
What exactly you are doing ? are you creating qvd and then loading ?
give more insights what exactly you want to achieve.
Vikas
Its a just SQL query with select statement. I'm not creating any QVD
Approximately how many records you are fetching from that SQL Query?
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.
>>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.
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.
can you show us the SQL Query?