Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Speedup results of replacing the Zotonic database driver in release 0.11.0
SERIAL TESTS
------------
Old Zotonic PGSQL implementation w/ custom pgsql_pool
11:38:26.495 [info] squery test result: 42667 queries in 15000 ms (select now())
11:38:41.495 [info] squery test result: 43696 queries in 15000 ms (select true)
11:38:56.495 [info] squery test result: 46251 queries in 15000 ms (select 'hello')
11:39:11.495 [info] squery test result: 28560 queries in 15000 ms (select count(*) from rsc)
11:39:26.495 [info] equery test result: 20125 queries in 15000 ms (select now())
11:39:41.495 [info] equery test result: 21695 queries in 15000 ms (select true)
11:39:56.495 [info] equery test result: 21934 queries in 15000 ms (select 'hello')
11:40:11.495 [info] equery test result: 16760 queries in 15000 ms (select count(*) from rsc)
11:40:26.495 [info] z_db test result: 18252 queries in 15000 ms (select now())
11:40:41.495 [info] z_db test result: 18654 queries in 15000 ms (select true)
11:40:56.495 [info] z_db test result: 18591 queries in 15000 ms (select 'hello')
11:41:11.496 [info] z_db test result: 13647 queries in 15000 ms (select count(*) from rsc)
New pgsql/pgsql implementation
11:45:15.677 [info] squery test result: 47855 queries in 15000 ms (select now())
11:45:30.677 [info] squery test result: 51757 queries in 15000 ms (select true)
11:45:45.677 [info] squery test result: 52844 queries in 15000 ms (select 'hello')
11:46:00.677 [info] squery test result: 30957 queries in 15000 ms (select count(*) from rsc)
11:46:15.677 [info] equery test result: 22199 queries in 15000 ms (select now())
11:46:30.677 [info] equery test result: 23881 queries in 15000 ms (select true)
11:46:45.677 [info] equery test result: 24186 queries in 15000 ms (select 'hello')
11:47:00.677 [info] equery test result: 17583 queries in 15000 ms (select count(*) from rsc)
11:47:15.677 [info] z_db test result: 19173 queries in 15000 ms (select now())
11:47:30.677 [info] z_db test result: 19719 queries in 15000 ms (select true)
11:47:45.677 [info] z_db test result: 20210 queries in 15000 ms (select 'hello')
11:48:00.677 [info] z_db test result: 13865 queries in 15000 ms (select count(*) from rsc)
PARALLEL TESTS
--------------
Old Zotonic PGSQL implementation w/ custom pgsql_pool
22:06:26.253 [info] z_db test result: 37729 queries in 15000 ms, 15 parallel test runners (select now())
22:06:41.258 [info] z_db test result: 38688 queries in 15000 ms, 15 parallel test runners (select true)
22:06:56.265 [info] z_db test result: 38883 queries in 15000 ms, 15 parallel test runners (select 'hello')
22:07:11.272 [info] z_db test result: 28609 queries in 15000 ms, 15 parallel test runners (select count(*) from rsc)
22:04:56.213 [info] z_db test result: 35499 queries in 15000 ms, 5 parallel test runners (select now())
22:05:11.215 [info] z_db test result: 36160 queries in 15000 ms, 5 parallel test runners (select true)
22:05:26.220 [info] z_db test result: 35926 queries in 15000 ms, 5 parallel test runners (select 'hello')
22:05:41.223 [info] z_db test result: 25512 queries in 15000 ms, 5 parallel test runners (select count(*) from rsc)
22:03:09.952 [info] z_db test result: 37610 queries in 15000 ms, 100 parallel test runners (select now())
22:03:25.003 [info] z_db test result: 39070 queries in 15000 ms, 100 parallel test runners (select true)
22:03:40.055 [info] z_db test result: 39042 queries in 15000 ms, 100 parallel test runners (select 'hello')
22:03:55.109 [info] z_db test result: 28585 queries in 15000 ms, 100 parallel test runners (select count(*) from rsc)
New poolboy (10 connections)
21:53:22.266 [info] z_db test result: 40663 queries in 15000 ms, 15 parallel test runners (select now())
21:53:37.272 [info] z_db test result: 40717 queries in 15000 ms, 15 parallel test runners (select true)
21:53:52.276 [info] z_db test result: 41451 queries in 15000 ms, 15 parallel test runners (select 'hello')
21:54:07.282 [info] z_db test result: 29693 queries in 15000 ms, 15 parallel test runners (select count(*) from rsc)
21:54:35.810 [info] z_db test result: 37310 queries in 15000 ms, 5 parallel test runners (select now())
21:54:50.813 [info] z_db test result: 38110 queries in 15000 ms, 5 parallel test runners (select true)
21:55:05.815 [info] z_db test result: 39038 queries in 15000 ms, 5 parallel test runners (select 'hello')
21:55:20.817 [info] z_db test result: 28144 queries in 15000 ms, 5 parallel test runners (select count(*) from rsc)
21:56:26.822 [info] z_db test result: 40179 queries in 15000 ms, 100 parallel test runners (select now())
21:56:41.863 [info] z_db test result: 41155 queries in 15000 ms, 100 parallel test runners (select true)
21:56:56.901 [info] z_db test result: 41952 queries in 15000 ms, 100 parallel test runners (select 'hello')
21:57:11.949 [info] z_db test result: 28364 queries in 15000 ms, 100 parallel test runners (select count(*) from rsc)
23:19:44.583 [info] z_db test result: 40260 queries in 15000 ms, 15 parallel test runners (select now())
23:19:59.588 [info] z_db test result: 40339 queries in 15000 ms, 15 parallel test runners (select true)
23:20:14.593 [info] z_db test result: 41292 queries in 15000 ms, 15 parallel test runners (select 'hello')
23:20:29.600 [info] z_db test result: 29571 queries in 15000 ms, 15 parallel test runners (select count(*) from rsc)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.