Each connection will take up a certain amount of memory, but memory is cheap these days.
If you are using a connection pool inside your application to connect to the server, then setting the number of connections to anything above (2 * no_cores on server) is probably going to be counter-productive. But you should try different settings and see what works for you. Jason Tesser wrote: > We use H2 on the file system meaning not just in memory. > > We have heavy load on it. Is there any reason I should not set the > maxConections to be 1000 or so? > > Thanks, > Jason Tesser > dotCMS Lead Development Manager > 1-305-858-1422 > -- > 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. -- 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.
