HI, Did you consider asynchronous SQL queries ? When all results are sent on the fly to the client and do not collected on server side.
On Fri, Feb 20, 2015 at 10:30 AM, Shivanandan Gupta < [email protected]> wrote: > 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. > -- Best regards, Andrey Lomakin. -- --- 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.
