• State Not Answered
  • Replies 2 replies
  • Subscribers 582 subscribers
  • Views 121 views
  • Users 0 members are here
Options
Related

Function TrnGetTable - Slow Export

Sebastian

Is there a way to pull data faster using the trendgetable function?

When I call the trendgetable function, it takes a very long time before the function returns data from a longer period, e.g. several months.

For example, if I want to export data from a period of half a year every 2 hours for 5 variables, it takes 8 minutes before the function returns the data.

IF sTagColumn1 <> "!" THEN
ErrSet(1);
TrnGetTable("OBIEKT."+ sTagColumn1, TimestampToTimeInt(t1), Resolution_h ,REP_RANGE/Resolution_h, TrendTable1, 1 + 0 + 12 +0,0);
ErrSet(0);
END

Parents
  • 0

    Hi  

    I'm not aware of any tricks, but perhaps breaking it up into smaller periods could help?

    You could also experiment with the Trend Server setting:

    ReadWatchTime=0 (this defaults to 1ms)

    MaxRequestLength=8000 (default 4000) 

    Please try this on a small stand alone test system first to observe the before and after settings and any impact to the Trend Server.

    Kind regards

    Olivier

Reply
  • 0

    Hi  

    I'm not aware of any tricks, but perhaps breaking it up into smaller periods could help?

    You could also experiment with the Trend Server setting:

    ReadWatchTime=0 (this defaults to 1ms)

    MaxRequestLength=8000 (default 4000) 

    Please try this on a small stand alone test system first to observe the before and after settings and any impact to the Trend Server.

    Kind regards

    Olivier

Children
No Data