Function testConnectionPooling

scripts/db/test-optimization.ts:89–117

()

}

async function testConnectionPooling() {
  console.log("\n🔄 Testing connection pooling...");

  try {
    // Test multiple concurrent connections
    const promises = Array.from({ length: 5 }, async (_, i) => {
      const client = await mongoDb;
      const db = client.db(process.env.DATABASE_NAME || 'pulse-db');
      const startTime = Date.now();

      // Simple operation
      await db.command({ ping: 1 });

      const duration = Date.now() - startTime;
      console.log(`   Connection ${i + 1}: ${duration}ms`);
      return duration;
    });

    const results = await Promise.all(promises);
    const avgTime = results.reduce((a, b) => a + b, 0) / results.length;

    console.log(`   📊 Average connection time: ${avgTime.toFixed(2)}ms`);
    console.log("   ✅ Connection pooling working correctly");

  } catch (error) {
    console.error("   ❌ Connection pooling test failed:", error);
    throw error;
  }
}

async function main() {
  try {