Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

raajaswin
Contributor 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
MVP & Luminary
MVP & Luminary

Re: Performance issue - Select query takes long time

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

Partner
Partner

Re: Performance issue - Select query takes long time

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.

Highlighted
raajaswin
Contributor III

Re: Performance issue - Select query takes long time

We need All columns and record as well.

Partner
Partner

Re: Performance issue - Select query takes long time

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 ..