Hello I cannot say if command cache works in orientdb 2.2.0 community.
I added this line in server.sh on a remote orientdb 2.2.0 ORIENTDB_SETTINGS="-Dprofiler.enabled=true -Dcommand.cache.enabled=true -Dcommand.cache.evictStrategy=INVALIDATE_ALL -Dcommand.cache.minExecutionTime=5 -Dcommand.cache.maxResultsetSize=500000000" to verify the settings are sent to orientdb by the os I executed: builder@orientdb2:/opt/orientdb/orientdb-community-2.2.0$ ps fax | grep java 13371 pts/0 S+ 0:00 \_ grep --color=auto java 13236 ? Sl 1:24 java -server -Xms512m -Xmx4g -Djna.nosys=true -XX:+HeapDumpOnOutOfMemoryError -XX:MaxDirectMemorySize=512g -Djava.awt.headless=true -Dfile.encoding=UTF8 -Drhino.opt.level=9 -Dprofiler.enabled=true* -Dcommand.cache.enabled=true -Dcommand.cache.evictStrategy=INVALIDATE_ALL -Dcommand.cache.minExecutionTime=5 -Dcommand.cache.maxResultsetSize=500000000* -Djava.util.logging.config.file=/opt/orientdb/orientdb-community-2.2.0/config/orientdb-server-log.properties -Dorientdb.config.file=/opt/orientdb/orientdb-community-2.2.0/config/orientdb-server-config.xml -Dorientdb.www.path=/opt/orientdb/orientdb-community-2.2.0/www -Dorientdb.build.number=develop@r79d281140b01c0bc3b566a46a64f1573cb359783; 2016-05-18 14:14:32+0000 -cp /opt/orientdb/orientdb-community-2.2.0/lib/orientdb-server-2.2.0.jar:/opt/orientdb/orientdb-community-2.2.0/lib/*:/opt/orientdb/orientdb-community-2.2.0/plugins/* com.orientechnologies.orient.server.OServerMain so settings are sent to the server JVM After that, I sent this SQL command *twice *(in the hope that second time orientdb sends the result right back to the user): SELECT FROM UserTrace LIMIT 5000 FETCHPLAN *:-1 *With command.cache.enabled=true* Processed 5000 users took 50 seconds Processed 5000 users in the 2nd time took 43 seconds *with command.cache.enabled=false* Processed 5000 users took 50 seconds Processed 5000 users in the 2nd time took 43 seconds How do I enable command.cache? And how do I know if command.cache is working? -- --- 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.
