Hello @Jay_Brown,
The Qlik Sense Enterprise and Qlik Web Connectors are in the same server.
We have performed a new test. We have read 1036 xlsx files. These files have a size of 15KB. We obtain the list of files with a List operation and then execute a FOR loop to read each file.
Qlik WebConnector takes 54 seconds however Amazon S3 takes 14 minutes.I attach screenshots with the result of each execution.
The code is the same except "FROM" sentence
Qlik WebConnector
LOAD *
FROM [$(vQwcConnectionName)] //URL to Qlik Web connector
(URL IS [$(fURL($(encoded_s3_filename)))],ooxml, no labels, header is 4 lines) //file name
where not IsNull(G);
Amazon s3 Connector:
LOAD *
FROM [$(swapsLibConnection)/$(s3_filename)] //Lib connection name + file name
(ooxml, no labels, header is 4 lines)
where not IsNull(G);
