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: 
raajaswin
Creator III
Creator III

Performance issue - Select query takes long time

Hi All,

I am having a Table with 40 columns and 28 Million Records. I am just doing a select * from that Table it takes 16 Minutes to load. Do we have any idea to further reduce this time?

4 Replies
marcus_sommer

Do you really need all columns and records from this table? If only the needed data are queried and transferred it might significantly reduce the run-times. Are after this the run-times yet too long you need to apply an incremental loading. Within the last two link-areas in this document: Advanced topics for creating a qlik datamodel you will find various examples how it could be done.

- Marcus

PabloTrevisan
Partner - Creator II
Partner - Creator II

Hi Aswin !

Using select * is never a good practice, I suggest you, start by filtering into the LOAD only the required fields, and then use the WHERE clause to limit the number of records in the table to be read.

raajaswin
Creator III
Creator III
Author

We need All columns and record as well.

PabloTrevisan
Partner - Creator II
Partner - Creator II

you can ask the DBA to create index in the table, or if there is a possibility to parallelize the job in the database. Oracle I already did ..