topic Most Efficient Data Source Format in QlikView https://community.qlik.com/t5/QlikView/Most-Efficient-Data-Source-Format/m-p/334837#M703501 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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.</P><P></P><P>What is the best datasource format for QlikView to read? </P><P></P><P>Is the actual loading/transformation into QlikView the bottleneck as opposed to the datasource? If so, I won't worry about the data type.</P><P></P><P>Thanks,</P><P>Rich</P></BODY></HTML> Thu, 02 Aug 2012 16:41:01 GMT Rich-HHE 2012-08-02T16:41:01Z Most Efficient Data Source Format https://community.qlik.com/t5/QlikView/Most-Efficient-Data-Source-Format/m-p/334837#M703501 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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.</P><P></P><P>What is the best datasource format for QlikView to read? </P><P></P><P>Is the actual loading/transformation into QlikView the bottleneck as opposed to the datasource? If so, I won't worry about the data type.</P><P></P><P>Thanks,</P><P>Rich</P></BODY></HTML> Thu, 02 Aug 2012 16:41:01 GMT https://community.qlik.com/t5/QlikView/Most-Efficient-Data-Source-Format/m-p/334837#M703501 Rich-HHE 2012-08-02T16:41:01Z Re: Most Efficient Data Source Format https://community.qlik.com/t5/QlikView/Most-Efficient-Data-Source-Format/m-p/334838#M703502 <HTML><HEAD></HEAD><BODY><P>Hi Rich,</P><P>probably creating of qvd files and incremental reload would be the good way for solving described issues.</P><P></P><P>regards</P></BODY></HTML> Fri, 03 Aug 2012 08:08:30 GMT https://community.qlik.com/t5/QlikView/Most-Efficient-Data-Source-Format/m-p/334838#M703502 2012-08-03T08:08:30Z