You might be able to do it by allocating more heap and less disk cache, but
really you should try to find a way to paginate your query (you'll probably
never have enough memory to select 1M records). There are several ways:
- use limit and @rid, e.g. "select * from widget limit 1000" then
"select * from widget where @rid > RID limit 1000" where RID is the max
@rid from the previous query
- organize your data by field value, e.g. "select * from widget where
color = 'blue'" then "select * from friom widget where color = 'red'"....
- organize your data into orient's clusters, which are a lot like other
database systems partitions -- cluster by time & date or whatever works for
your data set
- ...
On Friday, February 20, 2015 at 4:16:21 AM UTC-7, Shivanandan Gupta wrote:
>
> configuration of Xmx in server.bat is given below.
>
> :doneSetArgs
>
> if NOT exist "%CONFIG_FILE%" set
> CONFIG_FILE=%ORIENTDB_HOME%/config/orientdb-server-config.xml
>
> set LOG_FILE=%ORIENTDB_HOME%/config/orientdb-server-log.properties
> set WWW_PATH=%ORIENTDB_HOME%/www
> set ORIENTDB_SETTINGS=-Dprofiler.enabled=true
> set JAVA_OPTS_SCRIPT=-Xmx6g -Djna.nosys=true
> -XX:+HeapDumpOnOutOfMemoryError -Djava.awt.headless=true
> -Dfile.encoding=UTF8 -Drhino.opt.level=9
>
> rem ORIENTDB MAXIMUM HEAP. USE SYNTAX -Xmx<memory>, WHERE <memory> HAS THE
> TOTAL MEMORY AND SIZE UNIT. EXAMPLE: -Xmx512m
> set MAXHEAP=-Xmx6g
> rem ORIENTDB MAXIMUM DISKCACHE IN MB, EXAMPLE 8192 FOR 8GB
> set MAXDISKCACHE=-Dstorage.diskCache.bufferSize=40960
>
> call %JAVA% -server %JAVA_OPTS% %MAXHEAP% %JAVA_OPTS_SCRIPT%
> %ORIENTDB_SETTINGS% %MAXDISKCACHE%
> -Djava.util.logging.config.file="%LOG_FILE%"
> -Dorientdb.config.file="%CONFIG_FILE%" -Dorientdb.www.path="%WWW_PATH%"
> -Dorientdb.build.number="UNKNOWN@r${buildNumber}; 2015-01-28 18:33:00+0000"
> -cp "%ORIENTDB_HOME%\lib\*;" %CMD_LINE_ARGS%
> com.orientechnologies.orient.server.OServerMain
>
>
>
>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
