tag:blogger.com,1999:blog-6877629428951398731.post8581812200297247003..comments2024-01-09T09:02:40.935-08:00Comments on Java Persistence Performance: Batch Writing, and Dynamic vs Parametrized SQL, how well does your database perform?Jameshttp://www.blogger.com/profile/07275512393744882781noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-6877629428951398731.post-26197935736914356052016-04-04T00:21:48.108-07:002016-04-04T00:21:48.108-07:00Great to read, thanks alotGreat to read, thanks alotjaydatthttps://www.blogger.com/profile/11213885138274400418noreply@blogger.comtag:blogger.com,1999:blog-6877629428951398731.post-11292312015138482872013-05-29T11:12:01.566-07:002013-05-29T11:12:01.566-07:00Ok, I tested both, batch writing does make a diffe...Ok, I tested both, batch writing does make a difference, about 20-25%.Jameshttps://www.blogger.com/profile/07275512393744882781noreply@blogger.comtag:blogger.com,1999:blog-6877629428951398731.post-18214585159165868792013-05-29T10:25:24.468-07:002013-05-29T10:25:24.468-07:00HSQL and H2 are in-memory databases (there persist...HSQL and H2 are in-memory databases (there persistence is only through a log file), so I would not expect a big difference, as there is no network, and no storage. I'll give it a try though...Jameshttps://www.blogger.com/profile/07275512393744882781noreply@blogger.comtag:blogger.com,1999:blog-6877629428951398731.post-4916481621014847332013-05-29T07:39:42.556-07:002013-05-29T07:39:42.556-07:00Thanks for this write up. I'd be curious to s...Thanks for this write up. I'd be curious to see this for HyperSQL and H2 too.Anonymoushttps://www.blogger.com/profile/08587914007787890204noreply@blogger.com