Am 05.06.2012 20:11, schrieb Thomas Mueller:
Hi,
Depending on the operations, the embedded mode can be up to 6 times
faster than the server mode. This is if the server is running on the
same machine; localhost connections. If the server is on another
machine, the difference might be even bigger. This is according to the
performance test at http://h2database.com/html/performance.html (using
relatively simple statements).
Ah, I didn't notice that you can cross-reference the two tables.
Yep, network latency can slow down things considerably, but I have a
rough idea how much that is. The figures in those two tables didn't come
as a surprise :-)
On a tangent:
How about merging the two tables into one? E.g.
+--------------+------+--------------------+---------------------+
| | | Embedded | Client-Server |
| Test case | Unit +-----+--------+-----+------+--------+-----+
| | | H2 | HSQLDB | ... | H2 | HSQLDB | ... |
+--------------+------+-----+--------+-----+------+--------+-----+
| Simple: Init | ms | 241 | 431 | ... | 1715 | 2096 | ... |
+--------------+------+-----+--------+-----+------+--------+-----+
| ... | ... | ... | ... | ... | ... | ... | ... |
That would make comparing embedded vs. C-S easier, and still fit nicely
on the screen.
Well, on my screen, anyway... I won't be offended if you think that's a
bad idea :-)
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
