What is a DBA's definition of “batch”?
I've heard it being used in relation to SQLite sometimes but never completely understood what it means.
sqlite terminology
add a comment |
I've heard it being used in relation to SQLite sometimes but never completely understood what it means.
sqlite terminology
add a comment |
I've heard it being used in relation to SQLite sometimes but never completely understood what it means.
sqlite terminology
I've heard it being used in relation to SQLite sometimes but never completely understood what it means.
sqlite terminology
sqlite terminology
edited Nov 13 '18 at 6:07
Evan Carroll
32k969219
32k969219
asked Nov 13 '18 at 5:49
KentKent
141
141
add a comment |
add a comment |
4 Answers
4
active
oldest
votes
A batch is a series of SQL commands that are sent to the database server at once. This can be faster than sending each command individually because there is less network communication.
SQLite is an embedded database; SQL commands are executed directly by the SQLite library.
There is no separate server, so it would not make sense to have batches. SQLite does not have such batches.
Another meaning of "batch" might be the multi-row form of the INSERT command:
INSERT INTO MyTable(ID, Name) VALUES (1, 'this'), (2, 'that'), (3, 'whatever');
add a comment |
A group of one or more TSQL commands, such as SELECT or UPDATE, together can form a batch. GO
SSMS instruction is used to indicate the end of a batch hence has a role of a separator. You can use multiple GO
s to split the statements into multiple batches. Batches are useful during compilation time because SQL Server considers a batch a single unit and assigns a single execution plan to each batch. Batch differs from transaction because its statements are executed separately though they are the same execution plan. So if you have two batches, even if there is an error in the first batch the second batch is going to be execute. Note that both the batch itself and the GO command are not part of the TSQL instead they are useful facilities of SSMS.
3
This is an answer when working with Microsoft SQL Server and as such is only slightly relevant for OP. The question is asking for an answer related to SQLite.
– hot2use
Nov 13 '18 at 10:30
add a comment |
"Batch" is typically a verb, though it may also be a noun. Oftentimes, the technical term for the result of batching is a "transaction." And, more often then not, "batching" is to get around excessive commits with rollback points, or the need to cache or lock for a very long modification.
If used in the context outside of writes to a database, it can be said that you're batching "jobs" (as the units of work inside a batch). However, in the database the unit of work is normally a DML Statement and those are never referred to as jobs.
For more information see also Batch Processing (wikipedia)
add a comment |
Batch means "a BUNCH of TASKS"
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "182"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f222395%2fwhat-is-a-dbas-definition-of-batch%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
4 Answers
4
active
oldest
votes
4 Answers
4
active
oldest
votes
active
oldest
votes
active
oldest
votes
A batch is a series of SQL commands that are sent to the database server at once. This can be faster than sending each command individually because there is less network communication.
SQLite is an embedded database; SQL commands are executed directly by the SQLite library.
There is no separate server, so it would not make sense to have batches. SQLite does not have such batches.
Another meaning of "batch" might be the multi-row form of the INSERT command:
INSERT INTO MyTable(ID, Name) VALUES (1, 'this'), (2, 'that'), (3, 'whatever');
add a comment |
A batch is a series of SQL commands that are sent to the database server at once. This can be faster than sending each command individually because there is less network communication.
SQLite is an embedded database; SQL commands are executed directly by the SQLite library.
There is no separate server, so it would not make sense to have batches. SQLite does not have such batches.
Another meaning of "batch" might be the multi-row form of the INSERT command:
INSERT INTO MyTable(ID, Name) VALUES (1, 'this'), (2, 'that'), (3, 'whatever');
add a comment |
A batch is a series of SQL commands that are sent to the database server at once. This can be faster than sending each command individually because there is less network communication.
SQLite is an embedded database; SQL commands are executed directly by the SQLite library.
There is no separate server, so it would not make sense to have batches. SQLite does not have such batches.
Another meaning of "batch" might be the multi-row form of the INSERT command:
INSERT INTO MyTable(ID, Name) VALUES (1, 'this'), (2, 'that'), (3, 'whatever');
A batch is a series of SQL commands that are sent to the database server at once. This can be faster than sending each command individually because there is less network communication.
SQLite is an embedded database; SQL commands are executed directly by the SQLite library.
There is no separate server, so it would not make sense to have batches. SQLite does not have such batches.
Another meaning of "batch" might be the multi-row form of the INSERT command:
INSERT INTO MyTable(ID, Name) VALUES (1, 'this'), (2, 'that'), (3, 'whatever');
answered Nov 13 '18 at 11:57
CL.CL.
2,70511115
2,70511115
add a comment |
add a comment |
A group of one or more TSQL commands, such as SELECT or UPDATE, together can form a batch. GO
SSMS instruction is used to indicate the end of a batch hence has a role of a separator. You can use multiple GO
s to split the statements into multiple batches. Batches are useful during compilation time because SQL Server considers a batch a single unit and assigns a single execution plan to each batch. Batch differs from transaction because its statements are executed separately though they are the same execution plan. So if you have two batches, even if there is an error in the first batch the second batch is going to be execute. Note that both the batch itself and the GO command are not part of the TSQL instead they are useful facilities of SSMS.
3
This is an answer when working with Microsoft SQL Server and as such is only slightly relevant for OP. The question is asking for an answer related to SQLite.
– hot2use
Nov 13 '18 at 10:30
add a comment |
A group of one or more TSQL commands, such as SELECT or UPDATE, together can form a batch. GO
SSMS instruction is used to indicate the end of a batch hence has a role of a separator. You can use multiple GO
s to split the statements into multiple batches. Batches are useful during compilation time because SQL Server considers a batch a single unit and assigns a single execution plan to each batch. Batch differs from transaction because its statements are executed separately though they are the same execution plan. So if you have two batches, even if there is an error in the first batch the second batch is going to be execute. Note that both the batch itself and the GO command are not part of the TSQL instead they are useful facilities of SSMS.
3
This is an answer when working with Microsoft SQL Server and as such is only slightly relevant for OP. The question is asking for an answer related to SQLite.
– hot2use
Nov 13 '18 at 10:30
add a comment |
A group of one or more TSQL commands, such as SELECT or UPDATE, together can form a batch. GO
SSMS instruction is used to indicate the end of a batch hence has a role of a separator. You can use multiple GO
s to split the statements into multiple batches. Batches are useful during compilation time because SQL Server considers a batch a single unit and assigns a single execution plan to each batch. Batch differs from transaction because its statements are executed separately though they are the same execution plan. So if you have two batches, even if there is an error in the first batch the second batch is going to be execute. Note that both the batch itself and the GO command are not part of the TSQL instead they are useful facilities of SSMS.
A group of one or more TSQL commands, such as SELECT or UPDATE, together can form a batch. GO
SSMS instruction is used to indicate the end of a batch hence has a role of a separator. You can use multiple GO
s to split the statements into multiple batches. Batches are useful during compilation time because SQL Server considers a batch a single unit and assigns a single execution plan to each batch. Batch differs from transaction because its statements are executed separately though they are the same execution plan. So if you have two batches, even if there is an error in the first batch the second batch is going to be execute. Note that both the batch itself and the GO command are not part of the TSQL instead they are useful facilities of SSMS.
edited Nov 26 '18 at 9:33
Michael Green
14.5k83060
14.5k83060
answered Nov 13 '18 at 7:12
Eleonora GrigoryanEleonora Grigoryan
58314
58314
3
This is an answer when working with Microsoft SQL Server and as such is only slightly relevant for OP. The question is asking for an answer related to SQLite.
– hot2use
Nov 13 '18 at 10:30
add a comment |
3
This is an answer when working with Microsoft SQL Server and as such is only slightly relevant for OP. The question is asking for an answer related to SQLite.
– hot2use
Nov 13 '18 at 10:30
3
3
This is an answer when working with Microsoft SQL Server and as such is only slightly relevant for OP. The question is asking for an answer related to SQLite.
– hot2use
Nov 13 '18 at 10:30
This is an answer when working with Microsoft SQL Server and as such is only slightly relevant for OP. The question is asking for an answer related to SQLite.
– hot2use
Nov 13 '18 at 10:30
add a comment |
"Batch" is typically a verb, though it may also be a noun. Oftentimes, the technical term for the result of batching is a "transaction." And, more often then not, "batching" is to get around excessive commits with rollback points, or the need to cache or lock for a very long modification.
If used in the context outside of writes to a database, it can be said that you're batching "jobs" (as the units of work inside a batch). However, in the database the unit of work is normally a DML Statement and those are never referred to as jobs.
For more information see also Batch Processing (wikipedia)
add a comment |
"Batch" is typically a verb, though it may also be a noun. Oftentimes, the technical term for the result of batching is a "transaction." And, more often then not, "batching" is to get around excessive commits with rollback points, or the need to cache or lock for a very long modification.
If used in the context outside of writes to a database, it can be said that you're batching "jobs" (as the units of work inside a batch). However, in the database the unit of work is normally a DML Statement and those are never referred to as jobs.
For more information see also Batch Processing (wikipedia)
add a comment |
"Batch" is typically a verb, though it may also be a noun. Oftentimes, the technical term for the result of batching is a "transaction." And, more often then not, "batching" is to get around excessive commits with rollback points, or the need to cache or lock for a very long modification.
If used in the context outside of writes to a database, it can be said that you're batching "jobs" (as the units of work inside a batch). However, in the database the unit of work is normally a DML Statement and those are never referred to as jobs.
For more information see also Batch Processing (wikipedia)
"Batch" is typically a verb, though it may also be a noun. Oftentimes, the technical term for the result of batching is a "transaction." And, more often then not, "batching" is to get around excessive commits with rollback points, or the need to cache or lock for a very long modification.
If used in the context outside of writes to a database, it can be said that you're batching "jobs" (as the units of work inside a batch). However, in the database the unit of work is normally a DML Statement and those are never referred to as jobs.
For more information see also Batch Processing (wikipedia)
edited Nov 13 '18 at 6:06
answered Nov 13 '18 at 6:00
Evan CarrollEvan Carroll
32k969219
32k969219
add a comment |
add a comment |
Batch means "a BUNCH of TASKS"
add a comment |
Batch means "a BUNCH of TASKS"
add a comment |
Batch means "a BUNCH of TASKS"
Batch means "a BUNCH of TASKS"
answered Nov 13 '18 at 8:17
Erdinc AyErdinc Ay
1249
1249
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f222395%2fwhat-is-a-dbas-definition-of-batch%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown