Neo4j performance using PHP API

[Тарасов Константин]

i have database with ~1000 nodes and ~1000 relations 

(windows, neo4jphp, default server configuration)

Next query takes 300ms:

START root=node(1)
MATCH root-[r*..3]->tag
return collect(tag) as tags, collect(r) as rels

I think it is too slow. Maybe something is wrong? 

PS Also i've some magic :) When i place datebase to (system disk) SSD, execution time increase to 1000ms

[Mattias Persson]

2012/10/1 Тарасов Константин <terr...@gmail.com>

Would that be for the first run? Because caches aren't warmed up by then. Run your query at least two times within the same db instance.

--
 
 

--
Mattias Persson, [mat...@neotechnology.com]
Hacker, Neo Technology
www.neotechnology.com

[Michael Hunger]

Ist this the first execution?

Try to measure the second and later

Also you don't need to collect in your usecase as you don't have grouping values

Then you can also use order by

Sent from mobile device

--
 
 

[Тарасов Константин]

Would that be for the first run? Because caches aren't warmed up by then. Run your query at least two times within the same db instance.

at warming up it takes about 1000ms

and at second query - 300ms

(structure is tree with depth = 3)

[Тарасов Константин]

Ist this the first execution?

Try to measure the second and later

1st: 1000ms

2nd: 300ms

 

Also you don't need to collect in your usecase as you don't have grouping values

Then you can also use order by

i use collect() to prepare data for Javascript

you won't believe me, but collect(*) works faster! (300ms vs 800ms)

[Josh Adell]

Have you determined how much time is spent on the server vs. in your client code? What is the execution time if you execute the query in webadmin or the neo4j shell?

-- Josh

[terrasoff]

On Monday, October 1, 2012 8:30:49 PM UTC+4, Josh Adell wrote:

Have you determined how much time is spent on the server vs. in your client code? What is the execution time if you execute the query in webadmin or the neo4j shell?

hmm... shell time is ~20ms (after warm up)

php code is too simple to make mistake (i've measured execution time of this code)

    public function getTags() {
        $queryTemplate =
            'START root=node(1)
             MATCH root-[r*..3']->tag
             RETURN collect(tag) as nodes, collect(r) as rels
            ';


        $query = new NJ\Cypher\Query($this->getClient(), $queryTemplate);
        return $query->getResultSet($query);
    }

Seems, problems with PHP REST API

[Josh Adell]

How many nodes and relationships are returned by that query?

-- Josh

[terrasoff]

How many nodes and relationships are returned by that query?

first post:

~1000 nodes/ ~1000 relationships 

structure is tree

[Peter Neubauer]

So,
could you even check the timing with CURL and the treaming headers
set, so we know if it is the server or the client taking the time?

Cheers,

/peter neubauer

G: neubauer.peter
S: peter.neubauer
P: +46 704 106975
L: http://www.linkedin.com/in/neubauer
T: @peterneubauer

Wanna learn something new? Come to http://graphconnect.com

On Tue, Oct 2, 2012 at 9:26 AM, terrasoff <terr...@gmail.com> wrote:
> first post: ~1000 nodes/ ~1000 relationships
> structure is tree
>

> --
>
>

[Gil Hildebrand]

Any update on this? I am also using PHP API. Just wondering if you found the problem.

[Peter Neubauer]

Terasoff,
did you get any more timings on your case?

Cheers,

/peter neubauer

G: neubauer.peter
S: peter.neubauer
P: +46 704 106975
L: http://www.linkedin.com/in/neubauer
T: @peterneubauer

Neo4j 1.8 GA - http://www.dzone.com/links/neo4j_18_release_fluent_graph_literacy.html

> --
>
>

[Nadia Berloffa]

Hi!!
I've got the same problem. I'm using Neo4jphp. My query is:
MATCH n:concetto WHERE n.sing='alberi'
            OR n.plur='alberi' RETURN n;

If I execute it on webadmin it takes 448 ms, but with getResultSet() on Neo4jphp it takes 6 seconds.
How is it possible? How can I do?

Thanks
Nadia

[Michael Hunger]

do you have an index on either of these properties? If you do, can you try to use:

MATCH n:concetto WHERE n.sing='alberi'  RETURN n

UNION

MATCH n:concetto WHERE n.plur='alberi' RETURN n

--
You received this message because you are subscribed to the Google Groups "Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Sotiris Tsartsaris]

I had the same problem. Solved after increasing the java heap memory size and the memory php uses for script execution.

[Waseem Ahmad]

I have same problem ,my simple cypher query takes so much long time , can you please tell me how you increased the java heap memory size?

[Michael Hunger]

Please share your data model data sizes, config (messages.log) and cypher queries otherwise we can't help you.

--
You received this message because you are subscribed to the Google Groups "Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+un...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.