HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

What is a DBA's definition of "batch"?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
definitiondbabatchwhat

Problem

I've heard it being used in relation to SQLite sometimes but never completely understood what it means.

Solution

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');

Code Snippets

INSERT INTO MyTable(ID, Name) VALUES (1, 'this'), (2, 'that'), (3, 'whatever');

Context

StackExchange Database Administrators Q#222395, answer score: 4

Revisions (0)

No revisions yet.