[Improvement][API&DAO] Unnecessary Large Text Fields Returned in WorkflowInstanceMapper Queries

[njnu-seafish]

Search before asking

• I had searched in the issues and found no similar feature requirement.

Description

In WorkflowInstanceMapper.xml , all queries use which returns the complete set of fields, including multiple text/longtext type large fields :

Returning these unnecessary large fields leads to the following performance issues. This problem is particularly pronounced in the workflow instance table, as its data volume continuously expands over time.

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.