Method Sql.Sql()->streaming_query()

Method streaming_query

int|object streaming_query(object|string q, mixed ... extraargs)

Description

Sends an SQL query synchronously to the underlying SQL-server and returns the results streaming in untyped mode.

For the arguments, please see the query() function.

The result is returned as a streaming Sql.sql_result object in untyped mode. This allows for having results larger than the available memory, and returning some more info about the result. Returns 0 if the query didn't return any result (e.g. INSERT or similar). For the other arguments, they are the same as for the query() function.

Note

Streaming operation is not supported by all sql databases. If not supported, this function will fall back to calling big_query().

See also

big_query, streaming_typed_query