# HG changeset patch
# User Alain Mazy <am@orthanc.team>
# Date 1789563278 -7200
# Node ID 5c5392a01134febc63956750218ff85bd8527c34
# Parent  7021c0ff2a14a8b4dfd775d8220375991e1cf758
optimized single resources FindRequest

diff -r 7021c0ff2a14 -r 5c5392a01134 OrthancServer/Sources/Search/ISqlLookupFormatter.cpp
--- a/OrthancServer/Sources/Search/ISqlLookupFormatter.cpp	Tue Sep 15 16:19:35 2026 +0200
+++ b/OrthancServer/Sources/Search/ISqlLookupFormatter.cpp	Wed Sep 16 14:54:38 2026 +0200
@@ -806,7 +806,14 @@
     }
     else
     {
-      ordering = "ROW_NUMBER() OVER (ORDER BY " + strQueryLevel + ".publicId) AS rowNumber";  // we need a default ordering in order to make default queries repeatable when using since&limit
+      if (request.GetOrthancIdentifiers().IsDefined() && request.GetOrthancIdentifiers().DetectLevel() == queryLevel)
+      { // this is a single resource, no need for ordering (ordering may prevents a lot of optimizations from the query planner)
+        ordering = "0 AS rowNumber";
+      }
+      else
+      {
+        ordering = "ROW_NUMBER() OVER (ORDER BY " + strQueryLevel + ".publicId) AS rowNumber";  // we need a default ordering in order to make default queries repeatable when using since&limit
+      }
     }
 
     sql = ("SELECT " +