Summary
This knowledge base article will describe a new feature -- Grid column selection for text search in report builder. The feature will improve the report performance. This feature will be released in FlexNet Manager Suite 2015 R2 SP2 in the end of 2015.Synopsis
Every report created in report builder has a text search textbox field (As shown below)That is intended to be used for general-case search. Previously, every visible column in a report grid participated in construction of the search expression that sometimes resulted in performance issues especially when report contained too many columns with text data. To address the problem, a new facility has been introduced that allows user to explicitly choose columns for text search. This can improve search performance as only necessary data will be inspected.
Discussion
For a quick test of this feature, user can perform a following test:1. Using report builder create a report with many (10-20) text columns. Mark them all as searchable by checking ?Include in search? checkbox (shown below)
2. Navigate to report, input a string into a text search textbox and press ?Enter? button to start search. Try to estimate how much time the search takes.
3. Edit report in report builder, uncheck half of checkboxes near ?Include in search? label.
4. Repeat text search and compare running intervals. Normally, the search time should decrease.
*Note: different columns may have different impact on the search time, so performance results may improve even if one more column was excluded from search
Additional Information:
By unchecking ?Include in search? checkbox for a column user prevents this column name to appear in database query (i.e. in ?LIKE? statement). Advanced users may use SQL profiler tools to catch exact sql query that is executed by database engine to analyse its plan and resource consumption for fine-tuning the performance of report.
Was this helpful?
0/255
Upload Attachment
File Upload
Maximum file
size allowed is 3 MB.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Are you sure you want to cancel the case creation?
Case closed successfully
File Upload
Maximum file size allowed is 3 MB.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
File Upload
Maximum file
size allowed is 3 MB.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Case id: 00001065
Activity: Status change: 2 hours ago