Hi,
We have a setup where we load data into H2 database with more than 20
million rows distributed in different tables(1 table has more than 15
million rows and rest of the 5 million being distributed among different
tables). We have a reports setup which will query the database. We have SQL
SERVER REPORTING SERVICES (SSRS) as a report tool which communicates to H2
database through ODBC 64 driver with a dsn string.
The problem is when I load huge amount of data i.e., around 20
million rows , the SSRS reports are showing 'unable to connect to
datasource' error.
We tried restarting the server with a suspicion that there might be a lot
of open connections to database. After we restarted we were able to load
the reports for some time and later we again got the same error. And also
the loading time of reports is very slow, if we take the same report query
and execute on the H2 console, it is fast in fetching the results.
Is there any possible solution/work-around for these problems?
Regards,
Sumanth
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
