Hi All,
I am trying to select 100,000 records from a class (class is having
1,000,000 records and each record is having 74 properties) but I am
getting out of memory GC overhead limit exceeded error. My normal query
will be to select 1,000,000 records from the class and the class will have
70+ properties.
memory configuration used is given below in server.bat file
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
query executed is "select from abcd limit 100000"
2015-02-20 08:10:06:775 INFO {db=eigenin1} [TIP] Query 'select from
s_asset limit 100000' returned a result set with more than 10000 records.
Reduce it to improve performance and reduce RAM used
[OProfiler]java.lang.OutOfMemoryError: GC overhead limit exceeded
Dumping heap to java_pid3952.hprof ...
Dump file is incomplete: No space left on device
2015-02-20 08:14:36:759 INFO {db=eigenin1} [TIP] Query 'select from
s_asset limit 20000' returned a result set with more than 10000 records.
Reduce it to improve performance and reduce RAM used [OProfiler]
2015-02-20 08:16:48:239 INFO {db=eigenin1} [TIP] Query 'select from
s_asset limit 30000' returned a result set with more than 10000 records.
Reduce it to improve performance and reduce RAM used [OProfiler]
Thanks,
Shivanandan Gupta
--
---
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.
