Function test_insert_detailed_timing

tests/insert_detailed_analysis.rs:6–145

()

#[tokio::test]
async fn test_insert_detailed_timing() {
    println!("\n=== DETAILED INSERT TIMING ANALYSIS ===");
    
    // Use a temporary file instead of in-memory database
    let test_id = Uuid::new_v4().to_string().replace("-", "");
    let db_path = format!("/tmp/pgsqlite_test_{test_id}.db");
    
    let db = DbHandler::new(&db_path).expect("Failed to create database");
    
    // Create a session
    let session_id = Uuid::new_v4();
    db.create_session_connection(session_id).await.expect("Failed to create session connection");
    
    // Create test table
    db.execute_with_session("CREATE TABLE test_insert (id INTEGER PRIMARY KEY, name TEXT, value INTEGER)", &session_id)
        .await
        .expect("Failed to create table");
    
    // Warm up
    db.execute_with_session("INSERT INTO test_insert (name, value) VALUES ('warmup', 1)", &session_id)
        .await
        .expect("Failed to warm up");
    
    // Test different INSERT scenarios
    let test_cases = vec![
        ("Simple INSERT", "INSERT INTO test_insert (name, value) VALUES ('test1', 100)"),
        ("INSERT with single quotes", "INSERT INTO test_insert (name, value) VALUES ('test''s', 200)"),
        ("INSERT with numbers", "INSERT INTO test_insert (name, value) VALUES ('test123', 300)"),
        ("INSERT with longer values", "INSERT INTO test_insert (name, value) VALUES ('this is a much longer test string that might affect performance', 400)"),
    ];
    
    println!("\nIndividual INSERT timing:");
    for (desc, query) in &test_cases {
        let mut times = Vec::new();
        
        // Run each query 10 times to get average
        for _ in 0..10 {
            let start = Instant::now();
            db.execute_with_session(query, &session_id).await.expect("Failed to execute INSERT");
            times.push(start.elapsed());
        }
        
        let avg_time = times.iter().sum::<std::time::Duration>() / times.len() as u32;
        println!("{desc}: {avg_time:?} (avg of 10 runs)");
    }
    
    // Test parameterized INSERT through extended protocol
    println!("\nParameterized INSERT timing:");
    let param_query = "INSERT INTO test_insert (name, value) VALUES ($1, $2)";
    let mut param_times = Vec::new();
    
    for i in 0..10 {
        let start = Instant::now();
        db.execute_with_params(
            param_query,
            &[
                Some(format!("param{i}").into_bytes()),
                Some(i.to_string().into_bytes()),