Pike v8.0 release 1738

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