Method create_connection

src/session/pool.rs:167–184

(&self)

    }

    fn create_connection(&self) -> Result<Connection> {
        let conn = if self.path == ":memory:" {
            Connection::open_in_memory()?
        } else {
            Connection::open(&self.path)?
        };
        
        // Set pragmas for better performance
        conn.execute_batch(
            "PRAGMA journal_mode=WAL;
             PRAGMA synchronous=NORMAL;
             PRAGMA cache_size=-64000;
             PRAGMA temp_store=MEMORY;
             PRAGMA mmap_size=268435456;"
        )?;
        
        Ok(conn)
    }

    #[allow(dead_code)]
    async fn background_health_check(&self) {