Improve prepared statement name performance

porsager · porsager · commit 4a785bf8e7ea · 2020-04-08T17:23:21.000+02:00
diff --git a/lib/connection.js b/lib/connection.js
@@ -24,6 +24,7 @@ function Connection(options = {}) {
   let length = 0
   let messages = []
   let timer
+  let statement_id = 1
   let ended
   let open = false
   let ready = false
@@ -32,6 +33,7 @@ function Connection(options = {}) {
 
   const queries = Queue()
       , id = count++
+      , uid = Math.random().toString(36).slice(2)
       , connection = { send, end, destroy }
 
   const socket = postgresSocket(options, {
@@ -154,7 +156,7 @@ function Connection(options = {}) {
   }
 
   function prepare(sig, str, args, query) {
-    query.statement = { name: sig ? 'p' + Math.random().toString(30).slice(2) : '', sig }
+    query.statement = { name: sig ? 'p' + uid + statement_id++ : '', sig }
     return Buffer.concat([
       frontend.Parse(query.statement.name, str, args),
       bind(query, args)
