topic loadings in QlikView

loadings

Thu, 10 Feb 2011 14:12:49 GMT

Hi folks!!

I have a qlikview file I´ve created by myself with 15 tables. I think data arquitecture is already fine but when I reload 4 or 5 times without closing file, runtime is as high as I have to close process. If I switch off and switch on the computer, I have no problem to load data quickly.

I upload data diagram to show you my relations between tables. I have 1 GB RAM and I take off synthetic keys to bulid my own key fields. I reviewed all things I supose it could get me problems, but I don´t feel any improvement. File size is now 4.632 KB.

Is the file too big? How I could I improve memory requiered? What I can I do?

I appreciate any answer.

Thanks, Fiber9906

loadings

Anonymous — Thu, 10 Feb 2011 14:20:20 GMT

I currently work with a which is 3 times as big so the size can not be the problem I think.
From what I read I would rather think it is more related to your computer then to the Qlikview file.

Keep an eye on your running processes in your task manager, maybe that will give you some more information.

loadings

Thu, 10 Feb 2011 15:17:44 GMT

Hi!

I am agree with you, but this is what I have, so I have to solve this prblem if I could whiout changing my computer. I thing I thought it could be changed is that my own key fields are builded on the script as field1&'-'field2&'-'&field3 as keyname. Could be the process improve if I do those keys on my sql access view? I mean instead of wrintig on the code?

What do you think?

Appreciated. Fiber9906

loadings

Anonymous — Thu, 10 Feb 2011 15:24:45 GMT

I don't think that that would change anything because you say that it gets slower after a few reloads.
If the problem is in Qlikview it would be slow at the first load also IMO.