gremlin.graph=org.janusgraph.core.JanusGraphFactory

storage.backend=cassandrathrift

storage.hostname=10.0.0.254,10.0.0.1,10.0.0.2,10.0.0.5,10.0.0.6,10.0.0.15,10.0.0.16,10.0.0.17,10.0.0.18

storage.cassandra.keyspace=10k_DW

storage.batch-loading=true

storage.read-time=600000

storage.cassandra.thrift.cpool.min-evictable-idle-time=600000

storage.transactions=false

storage.cassandra.frame-size-mb=128

storage.cassandra.write-consistency-level=ANY

storage.cassandra.read-consistency-level=ONE

schema.default=none

schema.constraints=false

index.search.backend=solr

index.search.solr.mode=cloud

index.search.solr.zookeeper-url=10.0.0.254:21181

index.search.solr.configset=janusgraph-configset

cache.db-cache=true

cache.db-cache-clean-wait = 20

cache.db-cache-time = 180000

cache.db-cache-size = 0.25

I ran the following query in the gremlin console along with profiling and it took about 130s. Without profiling enabled, the times were similar (120s avg). 

gremlin> g.V().has('vertexType', 'Person').has('hasTag', textContainsRegex('.*Victor_Hugo.*')).inE().where(has('edgeType', 'post_hasCreator_person').or().has('edgeType', 'comment_hasCreator_person')).has('startDate', gt(554400)).outV().where(has('vertexType', 'Comment').or().has('vertexType', 'Post')).count().profile()

####################Similar Lines (Truncated)##############################

------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Please let me know if this is an expected query time (at least at the ballpark) for the given graph, setup and query.

Also, if someone has any ideas to improve the performance for this scenario, it would be much helpful.

Thanks.