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

Performance benchmarks #72

Open
jam231 opened this issue Apr 2, 2014 · 1 comment
Open

Performance benchmarks #72

jam231 opened this issue Apr 2, 2014 · 1 comment
Labels
enhancement performance

Comments

@jam231
Copy link
Owner

jam231 commented Apr 2, 2014

Methodology:
Benchmark -> Profile -> Optimize -> Benchmark -> ....

Benchmarks as of now (https://github.com/jam231/sia-clients/blob/master/Benchmarking/simple.rb):

Server + PostgreSQL 9.1 - Intel Core i5 m 430 @ 2.27GHz, gcc 4.8.1 target=x86_64, Ubuntu 12.04

simple.rb - Intel Core i5-3470 @ 3.2 GHz, jruby 1.7.4 on Java HotSpot 64-bit Server VM 1.7.0_07-b10, Windows 7

RPS: 2700 - 2900
jam231 added a commit that referenced this issue Apr 2, 2014
@jam231
Issue #72 - Profiler pointer query.prepare as quite costly. I replace…
9379e23 
…d it in all, except registerAccount(), methods of PostgreDataSession with QStringBuilder in query.exec(...). I left appropiate comments in header file. This replacement is safe as all the types used in queries are nonstrings, thus queries built via concatenation are sql injection proof.
@jam231
Copy link
Owner Author

jam231 commented Apr 2, 2014

Benchmarks as of now (https://github.com/jam231/sia-clients/blob/master/Benchmarking/simple.rb):

Server + PostgreSQL 9.1 - Intel Core i5 m 430 @ 2.27GHz, gcc 4.8.1 target=x86_64, Ubuntu 12.04

simple.rb - Intel Core i5-3470 @ 3.2 GHz, jruby 1.7.4 on Java HotSpot 64-bit Server VM 1.7.0_07-b10, Windows 7

RPS: 3875 - 4030

@jam231 jam231 changed the title Performance tuning. Performance benchmarks Apr 22, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement performance
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@jam231