Hi all. today i encountered a weird problem with query clause. My H2 is running standalone in Windows 2003. This H2 only has one table. The description is shown as follow:
create table boxindex (boxid varchar(16) not null, boxKey varchar(256) not null, featureBoxIndex varchar(128) not null, tenantId char(32) not null, showPriority int not null); create index box_Id on boxindex(boxid); create index tenant_Id on boxindex(tenantid); the query clause: select featureboxindex from boxindex where tenantId='xxxx' Yep.. inserting is exetremely fast. However when i tried to query some records from this table, i need to wait approximately 5 seconds. I use tcp connection in my application. The most amazing thing is when i did the same query in h2 console(web form), it only need 16-25ms. This table only have 30000 rows. a pretty small table indeed. I want to know do i miss sth in my connection configuration? or this h2 console use different connection for that? I use default parameter in fact. BTW: I use the latest version of H2. Thanks Regards GELIN YAN --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
