Inconsistent Load Times

Fri, 08 Mar 2013 10:23:43 GMT

Hello All,

Looking at the log files, we have seen the following inconsistency:

8:50 Load example:

08/03/2013 08:51:58: 1789 LEFT JOIN (Temp)

08/03/2013 08:51:58: 1790 LOAD

08/03/2013 08:51:58: 1791 TicketId,

08/03/2013 08:51:58: 1792 Date as SavedDate

08/03/2013 08:51:58: 1793 SQL SELECT TicketId, min(Date) as Date, Description

08/03/2013 08:51:58: 1794 FROM Database.dbo.Table with (NOLOCK)

08/03/2013 08:51:58: 1795 WHERE Description = 'Saved.'

08/03/2013 08:51:58: 1796 AND TicketId IN (SELECT Id FROM Database.dbo.Table2 with (NOLOCK)

08/03/2013 08:51:58: 1797 WHERE Flag IN ('1','2'))

08/03/2013 08:51:58: 1798 GROUP BY TicketId, Description

08/03/2013 08:52:35: 2 fields found: TicketId, SavedDate, 36,389 lines fetched

08/03/2013 08:59:00: Joining/Keeping

8:20 Load example:

08/03/2013 08:22:07: 1789 LEFT JOIN (Temp)

08/03/2013 08:22:07: 1790 LOAD

08/03/2013 08:22:07: 1791 TicketId,

08/03/2013 08:22:07: 1792 Date as SavedDate

08/03/2013 08:22:07: 1793 SQL SELECT TicketId, min(Date) as Date, Description

08/03/2013 08:22:07: 1794 FROM Database.dbo.Table with (NOLOCK)

08/03/2013 08:22:07: 1795 WHERE Description = 'Saved.'

08/03/2013 08:22:07: 1796 AND TicketId IN (SELECT Id FROM Database.dbo.Table2 with (NOLOCK)

08/03/2013 08:22:07: 1797 WHERE Flag IN ('1','2'))

08/03/2013 08:22:07: 1798 GROUP BY TicketId, Description

08/03/2013 08:22:36: 2 fields found: TicketId, SavedDate, 36,377 lines fetched

08/03/2013 08:22:38: Joining/Keeping

Is the time spent within the highlighted yellow Qlikview performing the join? Or is that it is still running the SQL query?

topic Inconsistent Load Times in QlikView