I'm fairly new to Jet Reports, primarily using Table Builder due to it's ease of use. I'm currently testing out a report that takes one table and links it to another table with a date field, primarily to gather records within a certain date range. From what I can tell, the report has to search every record, which is at least 500k records or more, then do the match to those within the range. This report takes well over an hour to run. Are there any techniques I should look into that can help improve the speed of this search?
Thanks.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello -
There are various ways to help get the best performance from your reports.
See these online articles for examples:
https://jetsupport.jetreports.com/hc/en-us/articles/218954028
https://jetsupport.jetreports.com/hc/en-us/articles/218954558
You have very accurately described what's going on in your case… the report has to search every record. This is the nature of a Table Builder – aka "NL(Table)" – report.
If you were to use the NL("Rows") function - probably nested as shown in the Grouping Report videos (https://jetsupport.jetreports.com/hc/en-us/articles/218954018-Jet-Essentials-Videos#reports) - you could probably optimize your report for your specific needs.
One option available to you for learning more is training. If that is something you want to pursue, information is available on the Jet Report website: https://www.jetreports.com/support/user-training/
Please sign in to leave a comment.