Project

General

Profile

Feature #3705

custom query/index/field reports

Added by Eric Faulhaber over 5 years ago. Updated over 5 years ago.

Status:
Test
Priority:
Normal
Assignee:
Eric Faulhaber
Target version:
-
Start date:
Due date:
% Done:

100%

billable:
No
vendor_id:
GCD
version:

unreferenced_database_fields.txt Magnifier (3.16 KB) Eric Faulhaber, 09/11/2018 03:22 AM

unindexed_queries.txt Magnifier (23.8 KB) Eric Faulhaber, 09/11/2018 03:22 AM

unused_database_indices.txt Magnifier (801 Bytes) Eric Faulhaber, 09/11/2018 03:22 AM

History

#1 Updated by Eric Faulhaber over 5 years ago

Customers have expressed interest in knowing the following about their applications:

  • a list of queries which don't have a matching index (default to the primary index);
  • a list of defined indices which are never used;
  • a list of database fields which are never referenced by application code.

In each case, we can only determine the use of these resources in static application code. Dynamic references defined at runtime (i.e., in dynamic buffers and queries) cannot be determined during conversion. Likewise, dynamically defined tables are out of scope for this task.

Ultimately, we want to add these reports to the source code analytics tool; however, currently, the information is only determined in steps of the conversion which are executed after the analytics tool generates its reports. The goal is to push these phases up in part, to allow this information to be collected early enough in the process to be included as analytics reports. However, for now, the reports will be simple text files generated during conversion.

#2 Updated by Eric Faulhaber over 5 years ago

Implemented support for all 3 reports in 3601a/11318. Example output for Hotel GUI project is attached.

#3 Updated by Eric Faulhaber over 5 years ago

Regression testing revealed some flaws. These are fixed in rev 11320. Continuing testing...

Also available in: Atom PDF