Thanks Andrey for your suggestion I will try this out. -- Shivanandan Gupta
On Monday, 23 February 2015 12:33:39 UTC+5:30, Andrey Lomakin wrote: > > 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] > <javascript:>> 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] <javascript:>. >> 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.
