[Libreoffice-bugs] [Bug 44954] New: delegate search to the database

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=44954

             Bug #: 44954
           Summary: delegate search to the database
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO Master
          Platform: All
        OS/Version: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Database
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: lionel at mamane.lu


Search within a database is done by downloading the data and looking inside it
ourself. It would be far more efficient to give that work to the SQL engine, by
a query like: SELECT primary_key FROM tableName WHERE searchCondition, and then
just jump to the row with that primary_key (or download the whole row if one
must).

That is not always possible. In particular, if the search option "Apply Field
Format" is enabled, then we have to download the data and apply the format and
then search ourselves. Same for "similarity search".

But SQL has even wildcard expressions ("LIKE" predicate), so other searches can
go the the database.

This would be much faster: less network traffic, but also the database engine
has indexes specially to make that operation faster!

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.