Databases Reference
In-Depth Information
Example A: Streaming Protocol Result Sets
Let's look at the case where your SQL statement creates result sets and
your application is accessing a streaming protocol database. In this
case, the connection is unavailable to process another SQL statement
until the first statement is executed and all results are returned to the
application. The time this takes depends on the size of the result set.
Figure 2-3 shows an example.
Streaming Protocol
Database
Statement requesting
result sets is sent.
Driver
CONNECTION
Result sets returned: All packets must be
received before connection is available.
Figure 2-3
Streaming protocol result sets
Example B: Streaming Protocol Updates
Let's look at the case where the SQL statement updates the database
and your application is accessing a streaming protocol database, as
shown in Figure 2-4. The connection is available as soon as the state-
ment is executed and the row count is returned to the application.
Streaming Protocol
Database
Update statement is sent.
Driver
CONNECTION
Row count is returned;
then connection is available.
Figure 2-4
Streaming protocol updates
