How to reuse a query result?

Common questions about 1C:Query language, Query builder tool and Data composition schema

Pages: 1

Stephanie Elliott	#1 People who like this:0 Yes/0 No Nov 19, 2012 09:34 AM
Active user Rating: 2 Joined: Jul 18, 2012 Company: Bristol IT Solutions, LLC	I'm trying to optimize my application and found some queries which are executed several times. Is it possible to execute those queries once and use the result in other queries?

ivan avdonin

People who like this:1 Yes/0 No

Nov 19, 2012 09:57 AM

Active user

Rating: 7
Joined: Sep 26, 2012
Company: individual

In Developer guide

Quote

8.3.2. Work with temporary tables
The 1C:Enterprise query language permits using temporary tables in queries.
Use of temporary tables helps to increase query performance and makes the text
of complex queries easier to understand.
Work with temporary tables is supported by two components:
- 1C:Enterprise script TempTablesManager object that stores temporary table
data;
- query language syntax that allows creation of new and use of existing temporary
tables

Pages: 1

Users browsing this topic (guests: 1, registered: 0, hidden: 0)

How to reuse a query result?

Download brochures