Hi, Could you post a complete standalone test case please?
Regards, Thomas On Thu, May 28, 2009 at 5:30 AM, Ansari S.H <[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
