topic Re: Performance Issue in QlikView

Performance Issue

Nagaraju_KCS — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am fetching data from SQL Server,

in my QVD generator whole application taking more than 20 mins. (Around i have 20 views)

Example:

Suppose i have A,B,C,D these are my View names.

this all tables A,B,C,D taking 20 mins..

in my C table i have 17 lacs records. remaining are less data.

If i am reload one single C table taking more than 30 mins, but whole application taking 20 mins.

What is the problem???

Thanks in Advance....

Re: Performance Issue

HirisH_V7 — Wed, 06 Apr 2016 04:09:24 GMT

Hi,

Single 'C' Table Means it will be based on the Resident or incremental Load's your'e Using and the Where condition's also will make a change.

Can u provide some more info reagarding the 'C' Table and transformations done it and also what kind of joins your'e using between all the tables.

-Hirish

Re: Performance Issue

Nagaraju_KCS — Wed, 06 Apr 2016 04:30:25 GMT

Nothing i have,

Just i am fetching from SQL, no where condition...

I don't have any calculation's... Just raw data... It's talking more than 30 mins....

because of that, I have implemented Incremental load it's taking more than 4 hours...

Incremental load working fine for other tables....

Any view problem????

Re: Performance Issue

sujeetsingh — Wed, 06 Apr 2016 04:44:53 GMT

What about your data model do it has some synthetic keys

Re: Performance Issue

Nagaraju_KCS — Wed, 06 Apr 2016 04:47:34 GMT

No,i.e QVD generator only

Re: Performance Issue

Wed, 06 Apr 2016 04:53:33 GMT

it's so simple just in the select * from table....instead of * copy the fields which are needed for the c table....

then automatically your reload time will decrease...if needed apply it for all tables in your application and check the performance of the reload.

I hope it will work for sure

Re: Performance Issue

PrashantSangle — Wed, 06 Apr 2016 05:27:59 GMT

Hi,

Yes Views are always consume extra time while fetching data from database.

also there are other several reason like

1: load on server - > when you run your extractor check is there any load on sql server database.

2: Concurrent request going on database server.

Regards

Re: Performance Issue

perumal_41 — Wed, 06 Apr 2016 05:49:35 GMT

Please check below scenarios in log file

1. reload single C table application and check how many records fetched

2. reload whole application and check how many records