I33Buckler

Results 10 comments of I33Buckler

> @I33Buckler AGE has utilities to load graph from CSV. Can it be used instead of plpgsql functions? https://age.apache.org/age-manual/master/intro/agload.html > Rather limiting for recommending a database extension to process the...

> @I33Buckler Your `create_stop_times` function is **O(N^3)** and that is inside a doubly nested loop that also does **SELECT**s from tables for each level. This can lead to as much...

A factor that I've noticed with regard to the noticeable performance difference between joining the PostgreSQL tables in the database and and joining the nodes is the difference in estimated...

> @I33Buckler If there is a cypher command causing a crash, or failing, we can try to look into that but, we will need more information about what is crashing...

> @I33Buckler If you are using that function, with the **O(N^3)** runtime, or greater, I wouldn't wait as it could take a very long time. You need to find a...

> @I33Buckler I'd be careful with StackOverflow answers that have few, if any, responses. That one, in particular, is not very helpful in my opinion. > Thanks. I referred to...

[@jrgemignani ](https://github.com/jrgemignani) Is it possible or are there plans to enable partitioning a graph node? That would help greatly with processing. At the moment the only solution obvious to me...

> > [@jrgemignani ](https://github.com/jrgemignani) Is it possible or are there plans to enable partitioning a graph node? That would help greatly with processing. At the moment the only solution obvious...

> @I33Buckler > > > I have done this to the table AllServices.Stop_Times > > Could you please elaborate how you did the partitioning? Is `AllServices.Stop_Times` an AGE table? AllServices.Stop_Times...

> @I33Buckler Currently, AGE tables are paritioned by their label name. Further partitoning a label's table may be useful. It may speed up (some) MATCH queries more than CREATE queries,...