Is h2 slow if number of rows are more.

[GoogleCodeExporter]

I am using h2-1.3.162 , and running it in mixed mode. The connection string 
which I use is something like this, 
“jdbc:h2:tcp://localhost:9092/mem:dbname;DB_CLOSE_DELAY=-1;”

The database has one table only and its pretty large(43 columns). 18 of them 
have indexes. 

My operations involve plenty of selects, inserts, and updates. And few delete 
queries too.
Problem I am facing is during selects, when database is empty the response time 
is pretty good, but as the number of rows start accumulating (20 thousand +) I 
start experiencing slowness in retrieval.

As soon as I delete the records the retrieval becomes faster.

The server is running with –server option. Memory allotted is –Xmx1024 

Please let me know if I am missing any configuration or my approach is messed 
up.

Original issue reported on code.google.com by ifteqar...@gmail.com on 2 Jan 2012 at 9:50

[GoogleCodeExporter]

Hi,

Did you read the performance documentation yet?

For questions, please use StackOverflow or the H2 Google Group. But even there, 
there is not enough info to help. Please provide a reproducible test case 
(create table, create index, some data, and most important the query you use).

Regards,
Thomas

Original comment by thomas.t...@gmail.com on 9 Jan 2012 at 7:01

• Changed state: Invalid