 |
Post AUcI1I7s1obp4bbRZo by [email protected] |
 |
More posts by [email protected] |
|
Post #AUcFXV3FCwNWZ56c4m by [email protected] |
|
0 likes, 0 repeats |
|
|
|
Indexes on #SQLite are so finicky. Add an index, get over a 5x improvement. A… |
|
|
|
Post #AUcHbzVi6SPG6BgpP6 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@encthenet half of my candidacy project for my PhD ended up being SQLite index … |
|
|
|
Post #AUcHbzafo0NOLa0n8i by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Unampho I have a feeling part of this is that unlike larger db's like post… |
|
|
|
Post #AUcI1I7s1obp4bbRZo by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Unampho In this case the additional index was preferred over a subset scan. T… |
|
|
|
Post #AUejJFavGTqBVstqi0 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
I think part of my problem is bad query planner in SQLite.It's prefering a … |
|
|
|
Post #AUekFzpjVXhTiTq6Qi by [email protected] |
|
0 likes, 0 repeats |
|
|
|
I likely can rewrite the query so the planner can do better. I think part of t… |
