Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-09-03 08:53 PM

Slow Extraction using SAP Connector

Hi all,

I'm currently pulling some data from the VBAP table in SAP. And the performance is very slow! The table size is 100mil records and is about 100GB is disk size. I loaded it for more than 12 hours and it only loaded 10mils records! This is with all the columns. I tried to reduce the number of columns to around 10, but the speed is still slow... only 30mils extracted in 5hours. Is this normal?

Is there anyway to improve the speed? Any thing that I can tweak in QlikView or SAP? The QV server is 64core with 64GB of RAM. QlikView's RAM usage is not high... less than 10GB. Plenty of free memory. Using SAP Connector 5.4, QlikView 9 SR5.

3,183 Views
0 Likes
21 Replies
Not applicable
‎2010-09-07 04:21 AM
Author

In response to suniljain

We are using Windows Server 2008 64bit.

149 Views
0 Likes
suniljain
Master
Master
‎2010-09-07 04:34 AM

In response to

Dear Khim,

pls contact related qliktech partner . For this issue. They will give you proper solution because there is no problem at configuration side .

or send issue details to support. @qliktech.com

Regards

Sunil

149 Views
0 Likes