| Extracted from Pike v7.8 release 866 at 2018-07-18.

[Top]
Sql
Sql.Sql

# Method Sql.Sql()->big_query()

Method big_query

  `int|object big_query(object|string q, mixed ... extraargs)`

Description

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

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

  The result is returned as an Sql.sql_result object in untyped 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

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

See also

  query , streaming_query