Thomas,
I've noticed that simple queries that compare ("=") varchar types
execute at about 1/3 the speed of PG (simple equals operations, not
using indexes or fulltext mode, also not using scalars or LIKE etc),
so I decided to profile h2 to see if there were any code regions I
could try to help optimize...
Looking at the code, you seem to be equally (or much more) proficient
at writing fast code than I would be, but I still wonder how you'd
assess the overhead.
launch:
java -Xrunhprof:cpu=times,depth=8 -Xmx256M -Dh2.returnLobObjects=false
-jar h2-1.2.130.jar org.h2.tools.Server -webAllowOthers -
tcpAllowOthers -tcpPort 9101 &:
profiler data:
http://kensystem.com/varchar-match.hprof.txt.zip
query:
SELECT * FROM tbl WHERE val='IMG/DCP_1303.JPG'
(where 'val' is varchar(64000))
Looking at the profiler output, it appears that most of the overhead
is pretty evenly distributed though assorted method -- that there is
not any single large bottleneck...
Do you have any plans to improve this and how?
Thanks again for a truly superb piece of software,
Ken
--
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.
