SQLite Forum

MAX performance
Login
Example (note you extend the list differently but bind the same):

```
select column1 as stream,
       (
        select max(id)
          from events
         where stream == column1
       ) as id
  from (
        values (?)
       )
;
```

You make the list of values longer by appending ,(?) to the values line.