Skip to content

Instantly share code, notes, and snippets.

View IEatCodeDaily's full-sized avatar

Raisal P Wardana IEatCodeDaily

View GitHub Profile
@IEatCodeDaily
IEatCodeDaily / gist:8436c97f11cd38a0071b33490836e289
Created February 13, 2026 02:52
Safe test for transaction query optimization - uses MONGO_URI env var, no hardcoded credentials
test-optimization.js
@IEatCodeDaily
IEatCodeDaily / test-optimization.js
Created February 13, 2026 02:51
Safe test script for transaction query optimization - uses MONGO_URI environment variable, no hardcoded credentials
#!/usr/bin/env node
const mongoose = require('mongoose');
const MONGODB_URI = process.env.MONGO_URI;
if (!MONGODB_URI) {
console.error('Missing MONGO_URI environment variable');
console.error('Usage: MONGO_URI="mongodb+srv://user:pass@host/db" node test-optimization.js');
process.exit(1);
@IEatCodeDaily
IEatCodeDaily / test-optimization.js
Created February 13, 2026 02:51
Safe test script for transaction query optimization - uses MONGO_URI env var, no hardcoded credentials
#!/usr/bin/env node
/**
* Test script to verify transaction query optimizations
* Uses MONGO_URI from environment variable
*/
const mongoose = require('mongoose');
const MONGODB_URI = process.env.MONGO_URI;
@IEatCodeDaily
IEatCodeDaily / comprehensive-benchmark.js
Created February 13, 2026 02:41
Comprehensive Transaction API Benchmark Script - Tests N+1 box lookup, aggregation, and batch lookup bottlenecks with before/after comparisons
#!/usr/bin/env node
/**
* COMPREHENSIVE TRANSACTION API BENCHMARK
*
* This script benchmarks all identified bottlenecks in the transaction API
* and outputs comparison data for PR documentation.
*
* Usage: node comprehensive-benchmark.js <MONGODB_URI>
*
@IEatCodeDaily
IEatCodeDaily / transaction-benchmark.js
Created February 13, 2026 02:12
MongoDB transaction query benchmark script - compares aggregation pipeline vs simple find() query performance
/**
* MongoDB Transaction Query Benchmark Script
*
* Compares performance of aggregation pipeline vs simple find() query
* RUN WITH: node transaction-benchmark.js <MONGODB_URI> <START_DATE> <END_DATE>
*
* Example:
* node transaction-benchmark.js "mongodb+srv://user:pass@host/db" "2026-02-01" "2026-02-28"
*
* SECURITY: This script only READS from database. No writes or modifications.