I need to generate an XML file for tax service agency and they are using special codes for the field names so I have a table with this codes (id, code, description) and it's used in other tables like one of the parameters.
When I generate the report I need to add this code to result table so I have two options:
1. Use a .dot syntax in a query and doing this include one table more to the query (tablename.parameter.code) or
2. Leave UUID in the query (tablename.parameter) and use a cashed function to get a code using the UUID
How to make the query and the future processing run more quickly? The resulting table could have up to millions of rows. The table containing the codes have only 30 records and this records repeatedly used.
The 1C:Enterprise developers forum