Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

richcalligan
Not applicable

Most Efficient Data Source Format

I am using the 64-bit Server. The primary data I'm loading to my server are dBase5 files. I have the 32-bit ODBC connection working, but, as you can imagine, it takes quite a while (hour or so) to load about 16 million records.

I converted the dBase file to a CSV and made a new project and tried loading the ~3.5GB csv file. The program became unresponsive and never even got to the "loading records" part.

What is the best datasource format for QlikView to read?

Is the actual loading/transformation into QlikView the bottleneck as opposed to the datasource? If so, I won't worry about the data type.

Thanks,

Rich

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Re: Most Efficient Data Source Format

Hi Rich,

probably creating of qvd files and incremental reload would be the good way for solving described issues.

regards

1 Reply
Not applicable

Re: Most Efficient Data Source Format

Hi Rich,

probably creating of qvd files and incremental reload would be the good way for solving described issues.

regards