Pivet
Pivet copied to clipboard
Provide more performant select statements for PeopleCodeProcessor
Currently the PeopleCodeProcessor does a full select on the table and then filters out the results in the program. It would be nice to craft more specific select statements to help filter out the rows returned.
For example a select statement can be written to account for project prefixes, or items prefixes, or both. This will limit the data that has to flow across the wire from the database.