Inconsistent Load Times

[#1]

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?