Performance Issue

[Nagaraju_KCS]

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

[HirisH_V7]

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

[Nagaraju_KCS]

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

[sujeetsingh]

What about your data model do it has some synthetic keys

[Nagaraju_KCS]

No,i.e QVD generator only

[#6]

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

[PrashantSangle]

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

[perumal_41]

Hi

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