Re: [sqlite] Cost of function call in a WHERE clause

oun...@mailinglists.sqlite.org] On Behalf Of Mario Bezzi >Sent: Thursday, 21 December, 2017 11:28 >To: SQLite mailing list >Subject: [sqlite] Cost of function call in a WHERE clause > >Hello, > >I would like to use a user defined scalar function in a where clause, >something li

[sqlite] Cost of function call in a WHERE clause

Hello, I would like to use a user defined scalar function in a where clause, something like: SELECT ColumnA, ColumnB, ColumnC FROM Table1 WHERE ColumnA = myfunct(X); X is constant.  I am concerned by the performance of such a query as I wonder if myfunct is called just once or once for