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@lists.freedesktop.org
ReportedBy: lio...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
