qvx versus csv? Whats the difference from an application perspective?

[martin_hamilton]

Hi

can anyone give a good reason to use a qvx versus a CSV file when loading data into qlikview?

i have an application processing data that can publish either and wondered what value each format has in regards to performance, scalability, etc

cheers

martin

[buzzy996]

source : QVX vs QVD

[Peter_Cammaert · Accepted solution]

A QVX file contains a binary pre-formatted copy of your records, while a csv file is pure text (a horrible version of pure text btw). A QVX-formatted file is more akin to a QVD than to a csv file. Much like the stream format that is being used between a Connector and the QlikView engine. I you want to save some time and resources when transferring data from your application to QlikView, I would suggest to use QVX. Performance will be better.

Peter

[martin_hamilton]

Thanks for the links and advise. Given the size of data and my ability to translate the data into QVX i think i will do that in my data extraction layer.

Many Thanks

Martin