SQLite Forum

SQLite search with text vs numeric field
Login
Does sqlite search performance get impacted if I do search on a numeric bigint or a fixed length 128 char string text field, assuming the table size is constant in both the cases and the fields are not primary keys? I assume the answer would be yes, if so, is there any benchmarks on how much would be the performance degrade or any rough estimates? How will the performance differ if index is created in both the cases?