Main > Forum > 1C:Enterprise Platform > 1C:Query language and DCS > How to reuse a query result?

Forum

How to reuse a query result?

Stephanie Elliott	#1 Nov 19, 2012 09:34 AM
Active user Points:: 0 Joined:: Jul 18, 2012	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?
	Profile

ivan avdonin

Nov 19, 2012 09:57 AM

Active user

Points:: 0
Joined:: Sep 26, 2012

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

Profile

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