-Xmx option

Posted:
Tue Mar 13, 2012 8:06 pm
by b0c1
Hi!
How can I increase the memory? I want to load a 100M+ sql script (dump), but I get out of memory error.
I tried dbeaver -vmargs -Xmx768m but it's not work...
Re: -Xmx option

Posted:
Wed Mar 14, 2012 5:51 pm
by Serge
Hi!
1. It is really not a good idea to execute huge scripts in SQL editor. 100M scipt will eat a few gigabytes of memory (due to syntax highlighting and other intellectual text editor features).
To execute huge scripts (e.g. database dumps) you may use "Execute script" tool (you may find it in Tools submenu of database context menu or "Database" main menu). "Execute scipt" tool is available only for MySQL. Oracle has similar tool "Execute in SQL*Plus". For other databases you should use some native client features.
2. Actually -vmargs works fine. E.g. you may start DBeaver with parameters "-vmargs -Xms500m" - and you will see that initial heap size is about 500Mb. I think 768Mb just not enough for your script (see p.1) so it doesn't make sense to increase maximum memory size for such big scripts.
Thanks!