Hi All, Currently using H2 DB Ver 1.1.113 and it seems performing slower than ver 1.1.112 in case of insert and update statements. In my testing, Database and client are running in same machine with Server Mode.
Machine Config: Win XP SP2, Intel Core2 Quad 2GHz. 3 GB RAM. Reason for being updated to Ver 1.1.113 because, the fix has been provided to control the size of index file. [In Ver 1.1.112 the index.db file is keep growing upon update statements] Statistics. H2 DB Ver 1.1.113 For Insert 100,000 records into below specified table takes 14 Secs. For Update 100,000 records into below specified table takes 17 Secs. H2 DB Ver 1.1.112 For Insert 100,000 records into below specified table takes 11 Secs. For Update 100,000 records into below specified table takes 14 Secs. Script: CREATE TABLE DATA_POINTS(ID INT IDENTITY,TAG_NAME VARCHAR (50),TAG_VALUE INT, STATUS TINYINT, TIMESTAMP TIMESTAMP); create index idx_data_points on data_points(tag_name); create index idx_alarm on alarms( tag_name); With Regs :Ansari S.H --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
