Download "Вложенные запросы VS Временные таблицы в запросах 1С"

"videoThumbnail Вложенные запросы VS Временные таблицы в запросах 1С

Объединить в запросе 1С

Объединить в запросе 1С

Channel: Школа 1С - видеоуроки бесплатно

Левое соединение в запросах 1С

Левое соединение в запросах 1С

Channel: Школа 1С - видеоуроки бесплатно

Запросы в 1С 8.3: СГРУППИРОВАТЬ, ИМЕЮЩИЕ

Запросы в 1С 8.3: СГРУППИРОВАТЬ, ИМЕЮЩИЕ

Channel: Школа 1С - видеоуроки бесплатно

Вертикальные области табличного документа 1С

Вертикальные области табличного документа 1С

Channel: Школа 1С - видеоуроки бесплатно

Регистры сведений в 1С 8.3

Регистры сведений в 1С 8.3

Channel: Школа 1С - видеоуроки бесплатно

Печатная форма 1С с выводом таблиц

Печатная форма 1С с выводом таблиц

Channel: Школа 1С - видеоуроки бесплатно

Расширения конфигураций 1С 8.3 за 45 минут! Как создать расширение и работать с ними

Расширения конфигураций 1С 8.3 за 45 минут! Как создать расширение и работать с ними

Channel: Школа 1С - видеоуроки бесплатно

Срез последних в запросах 1С

Срез последних в запросах 1С

Channel: Школа 1С - видеоуроки бесплатно

ИТОГИ в запросах 1С

ИТОГИ в запросах 1С

Channel: Школа 1С - видеоуроки бесплатно

Виртуальные таблицы VS Временные таблицы в запросах 1С

Виртуальные таблицы VS Временные таблицы в запросах 1С

Channel: Школа 1С - видеоуроки бесплатно

1С

1C

обучение 1С

программирование 1С

1С 8.3

1С 8.2

1с бухгалтерия

1С зуп

1С предприятие

вложенные запросы

временные таблицы

запросы 1с

00:00:02

today we have a small battle of the

00:00:05

century: nested queries against temporary

00:00:08

tables, these queries we wrote with you in

00:00:11

previous lessons, the nested query was

00:00:14

on the previous lesson, temporary tables in the

00:00:16

last lesson and you must remember that

00:00:19

they solve the same problem the task, if

00:00:23

briefly, can be described like this: we

00:00:24

slam him or

00:00:25

Ivanovo if you missed the previous

00:00:28

two videos, then it may be difficult for you to

00:00:30

understand what is happening here, so

00:00:33

please go back and watch them and

00:00:35

we will wait for you here,

00:00:36

so let’s make some noise and so we have a problem

00:00:40

that is solved using a nested

00:00:42

query and using a temporary

00:00:44

table, absolutely identical solutions are the

00:00:47

same in terms of

00:00:48

performance and the

00:00:50

result obtained, so what should we choose to

00:00:53

solve this particular problem, it doesn’t

00:00:55

matter what solution you

00:00:57

choose, but let’s imagine that

00:01:00

this is the movement table for you in the

00:01:03

future query you will need it more than once, but

00:01:06

at least 5 times, that is, you connect it from

00:01:08

one table to a second table and then

00:01:11

also, using the join method, attach it to

00:01:13

something and imagine

00:01:16

this situation and you know what you will have to

00:01:18

do if you use nested

00:01:20

queries,

00:01:21

you will have to carry this entire table

00:01:24

with you and write

00:01:27

it again every time you want to

00:01:29

use it, resulting in

00:01:31

duplicated code, then if you find an

00:01:34

error when forming this table, you

00:01:37

will have to correct this error in all

00:01:39

five places where you entered it, secondly, the

00:01:42

code is simply excessively voluminous and, in

00:01:45

principle, it is very inconvenient, and

00:01:48

lastly, but this is perhaps the most important thing,

00:01:50

if you actually

00:01:52

write such a construction several times in one query in

00:01:54

this nested table, it

00:01:56

will be re-formed each time and

00:01:59

therefore the speed of query execution

00:02:01

will leave much to be desired, what do

00:02:04

temporary tables offer us?

00:02:07

Modern tables in this regard are

00:02:09

much simpler, we just

00:02:11

described it once during

00:02:12

the growth, once we placed it in a temporary

00:02:15

table during this move, and now

00:02:18

we can access

00:02:21

this table as many times as we want

00:02:24

no more time is spent on generating this query, that

00:02:27

is, the table already exists and we can

00:02:29

use it as much as we want, instead of

00:02:31

dragging out this entire structure, we

00:02:34

simply write into it and move this

00:02:36

table already has everything we need, so

00:02:39

if you you need to use the

00:02:41

same table more than 1 time you always

00:02:46

need to choose the option with temporary

00:02:48

tables firstly it will be easier to

00:02:50

write

00:02:51

secondly it will be easier to read

00:02:53

thirdly it will just

00:02:55

work faster let's now think about in what

00:02:58

situation using a nested

00:03:00

query it may be more profitable

00:03:02

to use temporary ones tables, but for

00:03:04

example, in this situation, the use of a

00:03:07

nested query looks somehow more

00:03:10

concise and nicer than when

00:03:12

using temporary tables,

00:03:14

although the concepts feel great, of course,

00:03:16

everyone is subjective, and in cases where we are talking about

00:03:19

just one nested

00:03:21

query, perhaps such code is easier to write, although

00:03:24

this is also of course subjectively, nested queries do not have any

00:03:27

other more significant advantages,

00:03:30

so generally

00:03:32

speaking you can forget your

00:03:34

existence of nested queries and

00:03:36

always use temporary tables in

00:03:39

one hundred percent of cases, you

00:03:42

can solve all problems using

00:03:44

temporary tables, I

00:03:45

simply ignored such a concept as

00:03:47

nested queries,

00:03:48

why did I then In general, I’m telling you about them

00:03:50

in standard configurations, you

00:03:53

will see them, and outside of standard configurations, you will also

00:03:55

see them, that is, nested queries are used,

00:03:57

I use them myself, so you

00:04:00

need to know about them, but if you don’t want to,

00:04:02

you don’t have to use them, well, let’s

00:04:06

summarize, I think it’s obvious that in this

00:04:08

fight temporary

00:04:11

tables won, nested queries respectively

00:04:14

lost, if you agree with the outcome

00:04:16

of this battle, then like,

00:04:18

subscribe to the channel, write a cool

00:04:21

comment and see you in the next

00:04:24

video and there will be a new battle

Description:

В чем ключевое различие между вложенными запросами и временными таблицами в 1С. Преимущества и недостатки этих способов. Читайте статьи по 1С на нашем сайте: http://programmist1s.ru/materialyi-po-1s/

Preparing download options

Popular

HD video

Only sound

All

* — If the video is playing in a new tab, go to it, then right-click on the video and select "Save video as..."

** — Link intended for online playback in specialized players

Questions about downloading video

How can I download "Вложенные запросы VS Временные таблицы в запросах 1С" video?

http://unidownloader.com/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.
The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.
UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.
UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.

Which format of "Вложенные запросы VS Временные таблицы в запросах 1С" video should I choose?

The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.

Why does my computer freeze when loading a "Вложенные запросы VS Временные таблицы в запросах 1С" video?

The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.

How can I download "Вложенные запросы VS Временные таблицы в запросах 1С" video to my phone?

You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.

How can I download an audio track (music) to MP3 "Вложенные запросы VS Временные таблицы в запросах 1С"?

The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.

How can I save a frame from a video "Вложенные запросы VS Временные таблицы в запросах 1С"?

This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.

What's the price of all this stuff?

It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.