[BTS-2149] Improve performance of graph settings query (#21794)

jvolmer · web-flow · commit da0829f9a90a · 2025-06-03T15:13:14.000+02:00
diff --git a/CHANGELOG b/CHANGELOG
@@ -1,6 +1,8 @@
 devel
 -----
 
+* Improved performance of document-search query in graph settings UI (BTS-2149)
+
 * Upgraded bundled version of RocksDB to 9.5.
 
   The default values for the following RocksDB-related startup options were 
diff --git a/js/apps/system/_admin/aardvark/APP/react/src/views/graphV2/viewGraph/graphSettings/useNodeStartOptions.tsx b/js/apps/system/_admin/aardvark/APP/react/src/views/graphV2/viewGraph/graphSettings/useNodeStartOptions.tsx
@@ -19,23 +19,28 @@ const fetchOptions = async ({
   values: OptionType[];
 }) => {
   const inputSplit = inputValue.split("/");
-  const [collectionName] = inputSplit;
   const db = getCurrentDB();
   if (inputSplit.length === 1) {
     // filter here
     const finalOptions = inputValue
       ? collectionOptions?.filter(option =>
-          option.value.includes(inputValue)
-        ) || []
+        option.value.includes(inputValue)
+      ) || []
       : collectionOptions || [];
     return Promise.resolve(finalOptions);
   }
-  const valuesList = values.map(value => value.value);
+  const [collectionName, documentKey] = inputSplit;
+  const valuesList = values
+    .map(value => value.value.split("/"))
+    .filter(valueSplit => valueSplit.length > 1 && valueSplit[0] === collectionName)
+    .map(valueSplit => valueSplit[1]);
   const colQuery = aql`
       FOR doc IN ${db.collection(collectionName)}
-      FILTER doc._id >= ${inputValue} && STARTS_WITH(doc._id, ${inputValue}) 
-      FILTER doc._id NOT IN ${valuesList}
+      FILTER doc._key >= ${documentKey}
+      FILTER doc._key NOT IN ${valuesList}
+      SORT doc._key
       LIMIT 5
+      FILTER STARTS_WITH(doc._key, ${documentKey}) 
       RETURN doc._id`;
 
   const cursor = await db.query(colQuery);
