Leave feedback
  • Question

    Time between event retrieved and rule execution

Enter a new topic
  • Heikki Jaakkola Heikki Jaakkola
    0 likes 109 views

    Hi

    Just wanted to ask if this is normal behaviour? Here is a part of a log. It is taken between event retrieved script end and beginning of rule script. There is several rows of following script and it take 2 seconds to do this. (StreamServe 5.6.2 build 229)

     

    0421 124126 (0227) 99 ODBC: Executed SQL Statement: SELECT Version,State FROM ResourceStore WHERE ResourceStoreID=? 0421 124126 (0227) 99 ODBC: Executed SQL Statement: select getutcdate(),  PartID,ChunkIndex,Data from BinaryObject  where PartID = ? order by PartID, ChunkIndex    0421 124126 (0227) 99 ODBC: Executed SQL Statement: select getutcdate(),  ResourceStoreID,DocumentTypeID,PermissionsID,PrincipalObjectID,ResourceTypeID,Version,State,ResourceName,Description,ExternalID from ResourceStore  where ResourceStoreID = ?    0421 124126 (0227) 99 ODBC: Executed SQL Statement: select getutcdate(),  PartID,TrackerID,CreationDateTime,ExpiringDateTime,LastAccessTime,TotalBlobSize,ChunkSize,ContentType,ControlFlags from BlobInfo  where PartID = ?    0421 124126 (0227) 99 ODBC: Executed SQL Statement: SELECT Version,State FROM ResourceStore WHERE ResourceStoreID=? 0421 124126 (0227) 99 ODBC: Executed SQL Statement: select getutcdate(),  PartID,ChunkIndex,Data from BinaryObject  where PartID = ? order by PartID, ChunkIndex    0421 124126 (0227) 99 ODBC: Executed SQL Statement: select getutcdate(),  ResourceStoreID,DocumentTypeID,PermissionsID,PrincipalObjectID,ResourceTypeID,Version,State,ResourceName,Description,ExternalID from ResourceStore  where ResourceStoreID = ?    0421 124126 (0227) 99 ODBC: Executed SQL Statement: select getutcdate(),  PartID,TrackerID,CreationDateTime,ExpiringDateTime,LastAccessTime,TotalBlobSize,ChunkSize,ContentType,ControlFlags from BlobInfo  where PartID = ?    0421 124126 (0227) 99 ODBC: Executed SQL Statement: SELECT Version,State FROM ResourceStore WHERE ResourceStoreID=? 0421 124126 (0227) 99 ODBC: Executed SQL Statement: select getutcdate(),  PartID,ChunkIndex,Data from BinaryObject  where PartID = ? order by PartID, ChunkIndex 0421 124126 (0227) 99 ODBC: Executed SQL Statement: SELECT Version,State FROM ResourceStore WHERE ResourceStoreID=?0421 124126 (0227) 99 ODBC: Executed SQL Statement: select getutcdate(),  PartID,ChunkIndex,Data from BinaryObject  where PartID = ? order by PartID, ChunkIndex   0421 124126 (0227) 99 ODBC: Executed SQL Statement: select getutcdate(),  ResourceStoreID,DocumentTypeID,PermissionsID,PrincipalObjectID,ResourceTypeID,Version,State,ResourceName,Description,ExternalID from ResourceStore  where ResourceStoreID = ?   0421 124126 (0227) 99 ODBC: Executed SQL Statement: select getutcdate(),  PartID,TrackerID,CreationDateTime,ExpiringDateTime,LastAccessTime,TotalBlobSize,ChunkSize,ContentType,ControlFlags from BlobInfo  where PartID = ?   0421 124126 (0227) 99 ODBC: Executed SQL Statement: SELECT Version,State FROM ResourceStore WHERE ResourceStoreID=?0421 124126 (0227) 99 ODBC: Executed SQL Statement: select getutcdate(),  PartID,ChunkIndex,Data from BinaryObject  where PartID = ? order by PartID, ChunkIndex   0421 124126 (0227) 99 ODBC: Executed SQL Statement: select getutcdate(),  ResourceStoreID,DocumentTypeID,PermissionsID,PrincipalObjectID,ResourceTypeID,Version,State,ResourceName,Description,ExternalID from ResourceStore  where ResourceStoreID = ?   0421 124126 (0227) 99 ODBC: Executed SQL Statement: select getutcdate(),  PartID,TrackerID,CreationDateTime,ExpiringDateTime,LastAccessTime,TotalBlobSize,ChunkSize,ContentType,ControlFlags from BlobInfo  where PartID = ?   0421 124126 (0227) 99 ODBC: Executed SQL Statement: SELECT Version,State FROM ResourceStore WHERE ResourceStoreID=?0421 124126 (0227) 99 ODBC: Executed SQL Statement: select getutcdate(),  PartID,ChunkIndex,Data from BinaryObject  where PartID = ? order by PartID, ChunkIndex

     

    Friday 21 April, 2017