Changes between Version 12 and Version 13 of OtherTopics

Timestamp:

06/24/26 21:13:26 (2 weeks ago)

Author:

213087

Comment:

--

OtherTopics

@@ -128 +128 @@
               ->  Seq Scan on band b
 
-**Planning Time:  3.057 ms
-Execution Time: 0.838 ms**
-}}}
+}}}
+
+**Planning Time:  3.057 ms**
+
+
+**Execution Time: 0.838 ms****
 
 ==== EXPLAIN ANALYZE – After Indexes ====
@@ -157 +160 @@
                     ->  Seq Scan on venue_booking vb
               ->  Seq Scan on band b
-**
-Planning Time:  1.506 ms
-Execution Time: 0.492 ms**
-}}}
+}}}
+**Planning Time:  1.506 ms**
+
+
+**Execution Time: 0.492 ms**
 
 ==== Performance Comparison ====
@@ -259 +263 @@
                     ->  Seq Scan on event_rsvp r  (rows=104)
               ->  Seq Scan on attendance a  (rows=370)
-**
-Planning Time:  1.926 ms
-Execution Time: 1.254 ms**
-}}}
+}}}
+
+**Planning Time:  1.926 ms**
+
+
+**Execution Time: 1.254 ms**
 
 ==== EXPLAIN ANALYZE – After Indexes ====
@@ -287 +293 @@
                     ->  Seq Scan on event_rsvp r  (rows=119)
               ->  Seq Scan on attendance a  (rows=40)
-
-**Planning Time:  1.314 ms
-Execution Time: 1.122 ms**
-}}}
+}}}
+
+
+**Planning Time:  1.314 ms**
+
+
+**Execution Time: 1.122 ms**
 
 ==== Performance Comparison ====
@@ -320 +329 @@
 
 {{{
-#!javascript
+#!sql
 // Example: parameterized query for guest lookup
 const result = await pool.query(
@@ -331 +340 @@
 
 {{{
-#!javascript
+#!sql
 // Example: parameterized INSERT for new booking
 await pool.query(
@@ -348 +357 @@
 
 {{{
-#!javascript
+#!sql
 const bcrypt = require('bcrypt');
 const SALT_ROUNDS = 10;
@@ -373 +382 @@
 
 {{{
-#!javascript
+#!sql
 function requireAuth(req, res, next) {
     if (!req.session || !req.session.user) {