Method Sql.Sql()->big_typed_query()

Method big_typed_query

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

Description

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

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

The result is returned as an Sql.sql_result object in typed mode. This allows for having some more info about the result as well as processing the result in a streaming fashion, although the result itself wasn't obtained streamingly from the server. Returns 0 if the query didn't return any result (e.g. INSERT or similar).

Note

Typed mode is not supported by all sql databases. If not supported, an error is thrown.

Note

Despite the name, this function is not only useful for "big" queries. It typically has less overhead than typed_query also for ones that return only a few rows.

See also

query, typed_query, big_query, streaming_query