| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Stephen Denne <Stephen(dot)Denne(at)datamail(dot)co(dot)nz> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Minor performance improvements |
| Date: | 2007-02-27 04:24:09 |
| Message-ID: | Pine.BSO.4.64.0702262316480.1687@leary.csoft.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Tue, 27 Feb 2007, Stephen Denne wrote:
> I'm sad to say that I have not created any micro-benchmark tests, and
> unfortunately the improvements are very minor, and far overshadowed by
> the variability I get from my system.
>
I've created the attached test which tests the original code (Orig), your
code (Two), and my suggestion of an int4buf (Three) and got the following
surprising results:
jurka(at)tony:~/pg/jdbc/projects/perf/micro$ java -classpath . Tester Orig |
sort -n
11335
11370
11468
11484
11487
jurka(at)tony:~/pg/jdbc/projects/perf/micro$ java -classpath . Tester Two |
sort -n
12472
12476
12489
12492
12619
jurka(at)tony:~/pg/jdbc/projects/perf/micro$ java -classpath . Tester Three |
sort -n
4259
4562
4564
4611
4689
This shows your code is actually slower than the original code, although I
have no idea why that could be. It shows the int4buf idea as a clear
winner. I'm a little suspicious of the whole test because of your numbers
going up. Could you take a look at this and possibly confirm the results?
I'm not sure if windows has an equivalent to /dev/null, but I wanted to
avoid any impact of disk io.
Kris Jurka
| Attachment | Content-Type | Size |
|---|---|---|
| Tester.java | text/plain | 1.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Denne | 2007-02-27 05:29:34 | Re: Minor performance improvements |
| Previous Message | Stephen Denne | 2007-02-27 03:08:44 | Re: Minor performance improvements |