NetBSD/src 4qrF3Jjusr.sbin/makemandb whatis.c makemandb.c

   PR misc/54213: Fix performance of whatis(1) when no matches are found

   In revision 1.6 of whatis.c the query was modified to return matches for names found
   in MLINKS of the man pages as well. However it was slow. The reason probably being that it
   required a join. But more importantly the where condition on an FTS virtual table column
   is very slow. To avoid the join and the expensive where condition on the virtual table,
   add the name_desc column to the mandb_links table as well. This improves the performance
   of whatis(1) to the original level at the expense of slight data duplication.

   Bump the schema to force database rebuild to take account for the new column addition
VersionDeltaFile
1.8+13-17usr.sbin/makemandb/whatis.c
1.60+4-4usr.sbin/makemandb/makemandb.c
1.44+3-3usr.sbin/makemandb/apropos-utils.c
1.15+2-2usr.sbin/makemandb/apropos-utils.h
+22-264 files

UnifiedSplitRaw