Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ziadm
Specialist
Specialist

The best way to track the load time of a field ?

The best way to track the load time of a field ?

4 Replies
marcus_sommer

A field itself couldn't be tracked then it's always part from a table. Load times from tables could be tracked per load-logging (option within the document properties in tab general) or per time measurement like:

let vStart = now();

table:

Load * From xyz;

let vLoadTime = now() - $(vStart);

trace $(vLoadTime);

And of course this could be stored in a table, see: http://community.qlik.com/docs/DOC-7177#comment-20906

- Marcus

sunny_talwar

I may be totally incorrect Marcus, but isn't the load time for a specific field within a table same as the load time for the table itself?

Lets say there are two tables, Table 1 has 10 columns and Table 2 has 1000 columns, will Table 2 take longer to reload? It make sense that it should, but with my limited experience I have found out that number of columns haven't impacted the reload time for me. What did impact was the number of rows in the table.

A clarification would be greatly appreciated.

Thanks and regards,

Sunny

marcus_sommer

A field is always related to the other fields in its table (and isn't a single table to all other linked tables, too) and therefore the other fields may have an impact and often they does.

For example, if you load a sales-table with 50M rows it will be give a difference if you load only three fields with a date, a storeID and a value or if you included much more fields maybe an additionally timestamp which could be result in millions of unique fieldvalues instead of probably a few thousands unique fieldvalues. It won't be the same neither from table/file-size and load-times.

Otherwise if the amount of records aren't really big the performance of qlikview is often too fast to notice bigger differences.

- Marcus

ziadm
Specialist
Specialist
Author

Thanks Marcus