Does compressed file takes less time to loading using data loading activity as compare to uncompressed file?

Avatar

Avatar
Give Back 5
Level 3
parveshp7822672
Level 3

Likes

14 likes

Total Posts

37 posts

Correct reply

5 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 3
parveshp7822672
Level 3

Likes

14 likes

Total Posts

37 posts

Correct reply

5 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
parveshp7822672
Level 3

23-01-2019

Does compressed file take less time to load using data loading activity as compared to uncompressed file?

We have been loading a .csv file of 40GB to 60GB in adobe campaign. It takes a lot of time. If we compress it, size of a file is reduced 40 GB to 10 GB etc.

We know, we can upload the compressed file in adobe campaign using data loading activity.

But data loading activity firstly uncompressed the file and then load it. I am doubted it might take more time as compare to normal file upload.

Can you please confirm which file takes less time for loading?

Screen shot of Adobe documentation:

1674324_pastedImage_0.png

https://docs.campaign.adobe.com/doc/AC/en/WKF__General_operation_Importing_data.html

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

23-01-2019

Hi,

It takes the same amount of time either way, ordinary read vs zcat/gunzip -c.

Compression is still recommended for the disk savings, as csv data is highly compressible.

Thanks,

-Jon

Answers (0)