Hi Keith,
Thanks for your suggestion, actually the need here is to retrieve approx. 1
million records and it will be used by an application, so paginating will
not help us.
the disk cache is high because we want to make plocal to behave as
in-memory database with persistent data.
Thanks for your help.
-Shivanandan
On Saturday, 21 February 2015 02:50:37 UTC+5:30, Keith Freeman wrote:
>
> 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.
