benchmark.rs

use futures::future::try_join_all;
use std::env::var;
use std::error::Error;
use std::sync::Arc;
use std::time::{Duration,Instant};

constTASKS:u128 = 1000;
constQUERIES:u128 = 100;

#[test]
fnbenchmark() -> Result<(),Box<dynError>>{
let queries = TASKS*QUERIES;
let tcp_url = var("TCP_URL")?;
let uds_url = var("UDS_URL")?;
letmut tokio_rr = tokio::runtime::Runtime::new()?;

println!("Benchmark concurrency({}), queries({}):",TASKS, queries);
println!(" - async-postgres on async-std runtime:");
let elapsed = async_std::task::block_on(async_runtime(&tcp_url))?;
println!(" - tcp: {} us/q", elapsed.as_micros() / queries);
let elapsed = async_std::task::block_on(async_runtime(&uds_url))?;
println!(" - uds: {} us/q", elapsed.as_micros() / queries);
println!(" - async-postgres on tokio runtime:");
let elapsed = tokio_rr.block_on(tokio_runtime(&tcp_url))?;
println!(" - tcp: {} us/q", elapsed.as_micros() / queries);
let elapsed = tokio_rr.block_on(tokio_runtime(&uds_url))?;
println!(" - uds: {} us/q", elapsed.as_micros() / queries);
println!(" - tokio-postgres on tokio runtime:");
let elapsed = tokio_rr.block_on(tokio_postgres(&tcp_url))?;
println!(" - tcp: {} us/q", elapsed.as_micros() / queries);
let elapsed = tokio_rr.block_on(tokio_postgres(&uds_url))?;
println!(" - uds: {} us/q", elapsed.as_micros() / queries);
Ok(())
}

asyncfnasync_runtime(url:&str) -> Result<Duration,Box<dynError>>{
use async_std::task::spawn;
let(client, conn) = async_postgres::connect(url.parse()?).await?;
spawn(conn);
let shared_client = Arc::new(client);
let stmt = shared_client
.prepare("SELECT * FROM posts WHERE id=$1")
.await?;
let start = Instant::now();
let tasks = (0..TASKS).map(|_| {
let client = shared_client.clone();
let stmt = stmt.clone();
spawn(asyncmove{
let queries = (0..QUERIES).map(|_| client.query_one(&stmt,&[&1i32]));
try_join_all(queries).await
})
});
let results = try_join_all(tasks).await?;
let elapsed = start.elapsed();
// check
for rows in results {
for row in rows {
assert_eq!("MIT LICENSE", row.get::<_,&str>(1));
assert_eq!(
"Permission is hereby granted, free of charge, to any\nperson obtaining a copy of this software and associated\ndocumentation files (the \"Software\"), to deal in the\nSoftware without restriction, including without\nlimitation the rights to use, copy, modify, merge,\npublish, distribute, sublicense, and/or sell copies of\nthe Software, and to permit persons to whom the Software\nis furnished to do so, subject to the following\nconditions:\n\nThe above copyright notice and this permission notice\nshall be included in all copies or substantial portions\nof the Software.\n\nTHE SOFTWARE IS PROVIDED \"AS IS\", WITHOUT WARRANTY OF\nANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED\nTO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A\nPARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT\nSHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY\nCLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION\nOF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR\nIN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER\nDEALINGS IN THE SOFTWARE.",
 row.get::<_,&str>(2)
);
}
}
Ok(elapsed)
}

asyncfntokio_runtime(url:&str) -> Result<Duration,Box<dynError>>{
use tokio::spawn;
let(client, conn) = async_postgres::connect(url.parse()?).await?;
spawn(conn);
let shared_client = Arc::new(client);
let stmt = shared_client
.prepare("SELECT * FROM posts WHERE id=$1")
.await?;
let start = Instant::now();
let tasks = (0..1000).map(|_| {
let client = shared_client.clone();
let stmt = stmt.clone();
spawn(asyncmove{
let queries = (0..100).map(|_| client.query_one(&stmt,&[&1i32]));
try_join_all(queries).await
})
});
let results = try_join_all(tasks).await?;
let elapsed = start.elapsed();
// check
for rows in results {
for row in rows? {
assert_eq!("MIT LICENSE", row.get::<_,&str>(1));
assert_eq!(
"Permission is hereby granted, free of charge, to any\nperson obtaining a copy of this software and associated\ndocumentation files (the \"Software\"), to deal in the\nSoftware without restriction, including without\nlimitation the rights to use, copy, modify, merge,\npublish, distribute, sublicense, and/or sell copies of\nthe Software, and to permit persons to whom the Software\nis furnished to do so, subject to the following\nconditions:\n\nThe above copyright notice and this permission notice\nshall be included in all copies or substantial portions\nof the Software.\n\nTHE SOFTWARE IS PROVIDED \"AS IS\", WITHOUT WARRANTY OF\nANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED\nTO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A\nPARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT\nSHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY\nCLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION\nOF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR\nIN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER\nDEALINGS IN THE SOFTWARE.",
 row.get::<_,&str>(2)
);
}
}
Ok(elapsed)
}

asyncfntokio_postgres(url:&str) -> Result<Duration,Box<dynError>>{
use tokio::spawn;
use tokio_postgres::NoTls;
let(client, conn) = tokio_postgres::connect(url,NoTls).await?;
spawn(conn);
let shared_client = Arc::new(client);
let stmt = shared_client
.prepare("SELECT * FROM posts WHERE id=$1")
.await?;
let start = Instant::now();
let tasks = (0..1000)
.map(|_| {
let client = shared_client.clone();
let stmt = stmt.clone();
spawn(asyncmove{
let queries = (0..100).map(|_| client.query_one(&stmt,&[&1i32]));
try_join_all(queries).await
})
})
.collect::<Vec<_>>();
let results = try_join_all(tasks).await?;
let elapsed = start.elapsed();
// check
for rows in results {
for row in rows? {
assert_eq!("MIT LICENSE", row.get::<_,&str>(1));
assert_eq!(
"Permission is hereby granted, free of charge, to any\nperson obtaining a copy of this software and associated\ndocumentation files (the \"Software\"), to deal in the\nSoftware without restriction, including without\nlimitation the rights to use, copy, modify, merge,\npublish, distribute, sublicense, and/or sell copies of\nthe Software, and to permit persons to whom the Software\nis furnished to do so, subject to the following\nconditions:\n\nThe above copyright notice and this permission notice\nshall be included in all copies or substantial portions\nof the Software.\n\nTHE SOFTWARE IS PROVIDED \"AS IS\", WITHOUT WARRANTY OF\nANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED\nTO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A\nPARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT\nSHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY\nCLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION\nOF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR\nIN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER\nDEALINGS IN THE SOFTWARE.",
 row.get::<_,&str>(2)
);
}
}
Ok(elapsed)
}