[API reference](https://evolu.dev/docs/api-reference) › [@evolu/common](https://evolu.dev/docs/api-reference/common) › [Sqlite](https://evolu.dev/docs/api-reference/common/Sqlite) › SqliteQueryOptions

Defined in: [packages/common/src/Sqlite.ts:106](https://github.com/evoluhq/evolu/blob/e7144e2bbe9069362b62dec1b64a8aa922b8f1b0/packages/common/src/Sqlite.ts#L106)

Options for configuring [SqliteQuery](https://evolu.dev/docs/api-reference/common/Sqlite/interfaces/SqliteQuery) execution behavior.

## Properties

<a id="logexplainqueryplan"></a>

### logExplainQueryPlan?

```ts
readonly optional logExplainQueryPlan?: boolean;
```

Defined in: [packages/common/src/Sqlite.ts:120](https://github.com/evoluhq/evolu/blob/e7144e2bbe9069362b62dec1b64a8aa922b8f1b0/packages/common/src/Sqlite.ts#L120)

If set to `true`, logs the SQLite Explain Query Plan (EQP) for the query.
This can help analyze how SQLite plans to execute the query and identify
potential optimizations.

See: [https://www.sqlite.org/eqp.html](https://www.sqlite.org/eqp.html).

---

<a id="logqueryexecutiontime"></a>

### logQueryExecutionTime?

```ts
readonly optional logQueryExecutionTime?: boolean;
```

Defined in: [packages/common/src/Sqlite.ts:111](https://github.com/evoluhq/evolu/blob/e7144e2bbe9069362b62dec1b64a8aa922b8f1b0/packages/common/src/Sqlite.ts#L111)

If set to `true`, logs the time taken to execute the SQL query. Useful for
performance monitoring and identifying slow queries.

---

<a id="prepare"></a>

### prepare?

```ts
readonly optional prepare?: boolean;
```

Defined in: [packages/common/src/Sqlite.ts:129](https://github.com/evoluhq/evolu/blob/e7144e2bbe9069362b62dec1b64a8aa922b8f1b0/packages/common/src/Sqlite.ts#L129)

If set to `true`, explicitly prepares the query before execution. Prepared
statements can improve performance for repeated queries by reusing the
compiled query.

See: [https://sqlite.org/wasm/doc/trunk/api-oo1.md#db-prepare](https://sqlite.org/wasm/doc/trunk/api-oo1.md#db-prepare).