- Repeating single query
- QSqlQuery: 10000ms
- SOCI: 2500ms
- Prepared statement
- QSqlQuery: 7000ms
- SOCI: 750ms(?!)
Life of a programmer with business major, with no formal programming education experience at all. :P
QSqlQuery vs. SOCI: inserting 1000 times
Recently I'm using QtWebApp to develop an application, and I did some performance benchmark to select a database library in the backend. I selected QSqlQuery and SOCI as candidates, and tried to insert 10,000 rows at once. The result is as follows:
Subscribe to:
Post Comments (Atom)
PostgreSQL vs. SQLite: read & write in multithreaded environment
The start was humble. I needed to cache some data, and I thought just push them to database table and give index, and the rest will be datab...
Popular in Code{nested}
-
Unlike libssh, which uses cmake, libssh2 forces you to use Linux-like environment even in Windows, which eventually makes you to install MSY...
-
Net-SNMP는 거의 모든 리눅스 배포본에서 표준 SNMP 관리자로 사용되고 있는, 사실상의 표준이라고 할 수 있는 범용적인 도구입니다. 이번에 기회가 있어서 SNMP Trap 메시지를 받아서 처리는 도구를 만들게 되었는데, 개발중 중요하다고 생각되...
-
2019년 6월 19일부로 Qt 5.13.0이 발표 되었습니다. Qt 5.13.0의 새로운 기능 중에서 제 눈길을 꽤 끈 신기능이 하나 있었는데요....... Qt for WebAssembly 입니다. 그러니까...... Emscripten 을 사용해...
No comments:
Post a Comment