Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

improve query of wp_postparam to limit it to only needed IDs #1

Closed
bb-Ricardo opened this issue Jan 20, 2022 · 1 comment
Closed

improve query of wp_postparam to limit it to only needed IDs #1

bb-Ricardo opened this issue Jan 20, 2022 · 1 comment

Comments

@bb-Ricardo
Copy link
Owner

No description provided.

bb-Ricardo added a commit that referenced this issue Jan 20, 2022
@bb-Ricardo
fixes post param query, adds new config option and hash attributes
86ce447 
* improve speed of querying posparams by supplying a list of ids
* adds config option app.default_hash_cash_non_members
* adds a bunch of new Hash attributes

refs: #1
refs: #2
refs: #4
@bb-Ricardo
Copy link
Owner Author

before:

:~# siege -r 100 -c 50 -b https://www.berlin-h3.eu/api/v1/runs/all?last_update__gt=1642664363
** SIEGE 4.0.4
** Preparing 50 concurrent users for battle.
The server is now under siege...
Transactions:		        5000 hits
Availability:		      100.00 %
Elapsed time:		      121.37 secs
Data transferred:	        4.87 MB
Response time:		        1.21 secs
Transaction rate:	       41.20 trans/sec
Throughput:		        0.04 MB/sec
Concurrency:		       49.66
Successful transactions:        5000
Failed transactions:	           0
Longest transaction:	        2.30
Shortest transaction:	        0.19

after:

:~# siege -r 100 -c 50 -b https://www.berlin-h3.eu/api-dev/v1/runs/all?last_update__gt=1642664363
** SIEGE 4.0.4
** Preparing 50 concurrent users for battle.
The server is now under siege...
Transactions:		        5000 hits
Availability:		      100.00 %
Elapsed time:		       47.21 secs
Data transferred:	        4.87 MB
Response time:		        0.47 secs
Transaction rate:	      105.91 trans/sec
Throughput:		        0.10 MB/sec
Concurrency:		       49.67
Successful transactions:        5000
Failed transactions:	           0
Longest transaction:	        0.90
Shortest transaction:	        0.09

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@bb-Ricardo