SQLite Forum

Help speeding up this query
Login
You are amazing, Keith.
```
Run Time: real 1.275 user 0.062500 sys 0.312500
```
versus the old query:
```
Run Time: real 15.901 user 0.390625 sys 2.125000
```
It will take me years to understand what you did.  Well, I actually understand it. But to be able to come up with it.  I am actually going to study it because I have other queries that need the same fix.  Thanks.

josé