(scale: f64, sql_source: SpeedSqlSource)
| 4367 | } |
| 4368 | |
| 4369 | fn speed_cases(scale: f64, sql_source: SpeedSqlSource) -> Result<Vec<SpeedCase>> { |
| 4370 | let insert_1k = scaled_count(1_000, scale); |
| 4371 | let insert_25k = scaled_count(25_000, scale); |
| 4372 | let select_100 = scaled_count(100, scale); |
| 4373 | let select_5k = scaled_count(5_000, scale); |
| 4374 | let update_1k = scaled_count(1_000, scale); |
| 4375 | let update_25k = scaled_count(25_000, scale); |
| 4376 | let refill_12k = scaled_count(12_000, scale); |
| 4377 | let mut cases = vec![ |
| 4378 | SpeedCase { |
| 4379 | id: "1", |
| 4380 | label: format!("Test 1: {insert_1k} INSERTs"), |
| 4381 | sql: speed_create_and_insert("t1", insert_1k, false, false), |
| 4382 | operation_count: insert_1k, |
| 4383 | }, |
| 4384 | SpeedCase { |
| 4385 | id: "2", |
| 4386 | label: format!("Test 2: {insert_25k} INSERTs in a transaction"), |
| 4387 | sql: speed_create_and_insert("t2", insert_25k, true, false), |
| 4388 | operation_count: insert_25k, |
| 4389 | }, |
| 4390 | SpeedCase { |
| 4391 | id: "2.1", |
| 4392 | label: format!("Test 2.1: {insert_25k} INSERTs in single statement"), |
| 4393 | sql: speed_create_and_insert("t2_1", insert_25k, true, true), |
| 4394 | operation_count: insert_25k, |
| 4395 | }, |
| 4396 | SpeedCase { |
| 4397 | id: "3", |
| 4398 | label: format!("Test 3: {insert_25k} INSERTs into an indexed table"), |
| 4399 | sql: speed_indexed_create_and_insert("t3", "i3", insert_25k, false), |
| 4400 | operation_count: insert_25k, |
| 4401 | }, |
| 4402 | SpeedCase { |
| 4403 | id: "3.1", |
| 4404 | label: format!("Test 3.1: {insert_25k} INSERTs into an indexed table in single statement"), |
| 4405 | sql: speed_indexed_create_and_insert("t3_1", "i3_1", insert_25k, true), |
| 4406 | operation_count: insert_25k, |
| 4407 | }, |
| 4408 | SpeedCase { |
| 4409 | id: "4", |
| 4410 | label: format!("Test 4: {select_100} SELECTs without an index"), |
| 4411 | sql: speed_select_range("t2", select_100, 100), |
| 4412 | operation_count: select_100, |
| 4413 | }, |
| 4414 | SpeedCase { |
| 4415 | id: "5", |
| 4416 | label: format!("Test 5: {select_100} SELECTs on a string comparison"), |
| 4417 | sql: speed_select_like("t2", select_100), |
| 4418 | operation_count: select_100, |
| 4419 | }, |
| 4420 | SpeedCase { |
| 4421 | id: "6", |
| 4422 | label: "Test 6: Creating indexes".to_owned(), |
| 4423 | sql: "CREATE INDEX i2a ON t2(a);\nCREATE INDEX i2b ON t2(b);\n".to_owned(), |
| 4424 | operation_count: 2, |
| 4425 | }, |
| 4426 | SpeedCase { |
no test coverage detected