What is a DBA's definition of “batch”?
Clash Royale CLAN TAG#URR8PPP
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;
up vote
1
down vote
favorite
I've heard it being used in relation to SQLite sometimes but never completely understood what it means.
sqlite terminology
New contributor
add a comment |
up vote
1
down vote
favorite
I've heard it being used in relation to SQLite sometimes but never completely understood what it means.
sqlite terminology
New contributor
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I've heard it being used in relation to SQLite sometimes but never completely understood what it means.
sqlite terminology
New contributor
I've heard it being used in relation to SQLite sometimes but never completely understood what it means.
sqlite terminology
sqlite terminology
New contributor
New contributor
edited yesterday
Evan Carroll
29.8k860194
29.8k860194
New contributor
asked yesterday
Kent
91
91
New contributor
New contributor
add a comment |
add a comment |
4 Answers
4
active
oldest
votes
up vote
2
down vote
A group of one or more TSQL commands, such as SELECT or UPDATE, together can form a batch. GO
TSQL command 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 statement into multiple batches. Batches are useful during compilation time because SQL Server considers a batch a single unit and assign 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.
2
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
21 hours ago
add a comment |
up vote
1
down vote
"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 |
up vote
0
down vote
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 |
up vote
-3
down vote
Batch means "a BUNCH of TASKS"
add a comment |
4 Answers
4
active
oldest
votes
4 Answers
4
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
A group of one or more TSQL commands, such as SELECT or UPDATE, together can form a batch. GO
TSQL command 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 statement into multiple batches. Batches are useful during compilation time because SQL Server considers a batch a single unit and assign 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.
2
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
21 hours ago
add a comment |
up vote
2
down vote
A group of one or more TSQL commands, such as SELECT or UPDATE, together can form a batch. GO
TSQL command 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 statement into multiple batches. Batches are useful during compilation time because SQL Server considers a batch a single unit and assign 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.
2
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
21 hours ago
add a comment |
up vote
2
down vote
up vote
2
down vote
A group of one or more TSQL commands, such as SELECT or UPDATE, together can form a batch. GO
TSQL command 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 statement into multiple batches. Batches are useful during compilation time because SQL Server considers a batch a single unit and assign 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
TSQL command 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 statement into multiple batches. Batches are useful during compilation time because SQL Server considers a batch a single unit and assign 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.
answered yesterday
Eleonora Grigoryan
56813
56813
2
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
21 hours ago
add a comment |
2
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
21 hours ago
2
2
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
21 hours ago
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
21 hours ago
add a comment |
up vote
1
down vote
"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 |
up vote
1
down vote
"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 |
up vote
1
down vote
up vote
1
down vote
"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 yesterday
answered yesterday
Evan Carroll
29.8k860194
29.8k860194
add a comment |
add a comment |
up vote
0
down vote
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 |
up vote
0
down vote
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 |
up vote
0
down vote
up vote
0
down vote
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 19 hours ago
CL.
2,46011114
2,46011114
add a comment |
add a comment |
up vote
-3
down vote
Batch means "a BUNCH of TASKS"
add a comment |
up vote
-3
down vote
Batch means "a BUNCH of TASKS"
add a comment |
up vote
-3
down vote
up vote
-3
down vote
Batch means "a BUNCH of TASKS"
Batch means "a BUNCH of TASKS"
answered 23 hours ago
Erdinc Ay
1269
1269
add a comment |
add a comment |
Kent is a new contributor. Be nice, and check out our Code of Conduct.
Kent is a new contributor. Be nice, and check out our Code of Conduct.
Kent is a new contributor. Be nice, and check out our Code of Conduct.
Kent is a new contributor. Be nice, and check out our Code of Conduct.
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
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
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
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
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