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

#2

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

Subscribe

Pages: 1

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

/* Улучшаем читаемость списков в документации */ .workarea ul, .content ul { margin: 15px 0 20px 25px !important; padding: 0 !important; list-style-type: disc !important; } .workarea li, .content li { margin-bottom: 8px !important; padding-left: 5px !important; line-height: 1.6 !important; } /* Ультимативный фикс для всех уровней заголовков в контенте */ .workarea h1, .workarea h2, .workarea h3, .workarea h4, .workarea h5, .workarea h6, .content h1, .content h2, .content h3, .content h4, .content h5, .content h6, div[id*="content"] h5, div[class*="content"] h5 { display: block !important; font-weight: 700 !important; color: #005aa0 !important; /* Наш фирменный синий */ text-transform: none !important; margin-top: 30px !important; margin-bottom: 15px !important; line-height: 1.2 !important; font-family: Arial, sans-serif !important; } /* Принудительные размеры в пикселях (чтобы не зависеть от % или em) */ .workarea h1, .content h1 { font-size: 28px !important; } .workarea h2, .content h2 { font-size: 24px !important; } .workarea h3, .content h3 { font-size: 21px !important; } .workarea h4, .content h4 { font-size: 19px !important; } .workarea h5, .content h5 { font-size: 18px !important; } /* Для 5 решеток ##### */ .workarea h6, .content h6 { font-size: 16px !important; } /* Фикс, если Битрикс добавил лишние отступы перед списками после заголовка */ .workarea h5 + ul, .content h5 + ul { margin-top: 5px !important; }