Re: Performance Issue on Large Table
Dominique Pellé <[email protected]> Sun, 23 Feb 2020 20:40:43 +0100
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CAON-T_iGwvzLOVmT7Bw4-6akrjnuLESNQYY-p-u+Qxb_ZVX-kw@mail.gmail.com> |
Chip Beaulieu <[email protected]> wrote: > I also recently vacuumed the file. The issue really showed up after the FTS5 was > setup on the table. I suspect it’s got something to do with the triggers more than > the indexes. I am definitely open to suggestions. I’ve not been able to find much > info on the internet to optimize updates to tables with FTS. If the performance issue is about updating the FTS index, then maybe tweaking the 'automerge' feature can help. See: https://www.sqlite.org/fts5.html#the_automerge_configuration_option If you don't need NEAR or phrase queries, then perhaps setting details=column can help speeding up re-indexing (at least it reduces the index size). See: https://www.sqlite.org/fts5.html#the_detail_option Regards Dominique _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users