On 23 Feb 2020, at 7:23pm, Richard Damon <rich...@damon-family.org> wrote:
> I'm not sure that form of division would be good. One basic rule of database > normalization is that you don't break-up data based on the value of one of > the fields because you can't make the table to lookup data from be taken from > a field you get in a query. People who study the bible often want to look up different versions of the same verse at once, so they can compare the translations and wording. This suggests that splitting up the text by different versions would be a bad idea. I would rather figure out the underlying problem, but I made a decision some time ago not to understand the FTS parts of SQLite (because I never needed it for my own work). So I'm sorry I can't help on the performance issues. The timings just seem too long for a SQLite database which isn't using FTS. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
