[sqlite] Cost of function call in a WHERE clause

[Mario Bezzi]

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 every row.

I know I may probably determine it by reading SQLite generated pseudo 
code, but I am not fluent at it.

Thank you in advance.

mario

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users