Improve efficiency of single entity search indexing

diff --git a/app/Services/SearchService.php b/app/Services/SearchService.php
index ae8dd008a86ef81b220b580c59288750414494dd..ef11de72864f579c3baa25291f2a41e1c666517a 100644 (file)
--- a/app/Services/SearchService.php
+++ b/app/Services/SearchService.php
@@ -100,7 +100,11 @@ class SearchService
         $nameTerms = $this->generateTermArrayFromText($entity->name, 5);
         $bodyTerms = $this->generateTermArrayFromText($entity->getText(), 1);
         $terms = array_merge($nameTerms, $bodyTerms);
-        $entity->searchTerms()->createMany($terms);
+        foreach ($terms as $index => $term) {
+            $terms[$index]['entity_type'] = $entity->getMorphClass();
+            $terms[$index]['entity_id'] = $entity->id;
+        }
+        $this->searchTerm->newQuery()->insert($terms);
     }
 
     /**
@@ -121,7 +125,7 @@ class SearchService
 
         $chunkedTerms = array_chunk($terms, 500);
         foreach ($chunkedTerms as $termChunk) {
-            $this->searchTerm->insert($termChunk);
+            $this->searchTerm->newQuery()->insert($termChunk);
         }
     }