topic Re: Performance Issue in QlikView

Performance Issue

saumyashah90 — Fri, 06 Dec 2013 04:10:58 GMT

Hi Guyz,

I have source file this

Here you can see there is no file type(this file comes through unix comet job)

when i load this in qlikview with ^ as delimiter

Yo can see here by default it take txt format.

1)My question is when i convert this file into txt and then load it instead without converting , QlikView relaod takes place in 15 secs or 1 min,

but wheni reload it without any extension like above oic, it take 15 mins to reload.

why is that problem occuring(both are the same file having same data),what could be done?

2) what is this msq ? i mean what does it mean?

Please try to answer .

Re: Performance Issue

Mon, 09 Dec 2013 15:09:49 GMT

You could exceute a Robocopy command to rename the file with a .txt extension to improve the load time.

Then load the file.

Re: Performance Issue

saumyashah90 — Tue, 10 Dec 2013 06:34:27 GMT

any ways by automating it and not doing manual work

Re: Performance Issue

salto — Tue, 10 Dec 2013 07:42:30 GMT

In the server you can schedule a task that runs a .cmd or .bat file, that renames the file adding it an extension.

Open notepad and write:

rename PMCADSOutliersxxxxxx PMCADSOutliersxxxxxx.txt

This will rename the file.

Save this file as Renamefile.cmd in a folder on the server that hosts the file, and set it to run as a scheduled task (in Windows) before Qlikview loads it, and that is all.

Hope this helps.