Did anyone do some benchmarks how the insert-speed of FTS compares to a TEXT INDEX column? I don't need many of the extra features of FTS, because I always need to look up rows by prefix or exact match, and both can be implemented efficiently via TEXT INDEX too. But if the overhead is comparable, I'd rather use FTS. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
- [sqlite] FTS vs INDEX Fabian
- Re: [sqlite] FTS vs INDEX Black, Michael (IS)
- Re: [sqlite] FTS vs INDEX Fabian
- Re: [sqlite] FTS vs INDEX Black, Michael (IS)
- Re: [sqlite] FTS vs INDEX Alexey Pechnikov
- Re: [sqlite] FTS vs INDEX Fabian
- Re: [sqlite] FTS vs INDEX Alexey Pechnikov
- Re: [sqlite] FTS vs INDEX Scott Hess
- Re: [sqlite] FTS vs INDEX Fabian
- Re: [sqlite] FTS vs INDEX Scott Hess
- Re: [sqlite] FTS vs INDEX Alexey Pechnikov