Smart Notification Limits?

 2 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
popsdrown
New Member
Posts: 3
New Member
    I believe there is a limit to the number of records that can be processed on a smart notification. Does anybody know what it is? I seem to recall seeing somewhere that it was around 1000.
    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
      The only limit you will hit are those put upon you by your database repository (ie tablespace, quota, record size, etc). Ofcoarse the larger the row set the longer it will take to process and update. For any large record sets, be sure you tick the check box on the last step of the infoset editor to identify it as a Very Large Infoset (>20000 records), that then creates a physical table in the LawsonRS database that will hold those records. Otherwise all data is encoded to binary and stored in a field in a table.

      hth
      matt
      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
      Will
      Veteran Member
      Posts: 39
      Veteran Member
        When ticking the +20k infoset option, data is going to the LawsonSN DB and each infoset is referenced as INFOSET_xxxx (xxx being the infoset ID) by way of table.

        It is generally not a good idea to have infosets with more than 20k rows as you will certainly run into performance issues. A good rule of thumb is to capture only the latest records from Lawson corresponding to the latest transactions depending on what you are notifiying. Also you may want to consolidate data at the query level (provinding you're using an ODBC datasource), this is also a good idea to leave this work to the query itself.