How to display a large graph?

Nov 17, 2014 at 7:53 AM
I have a hierarchy stored in database in id, parent_id form.
It has millions nodes.
As I understand I can read all nodes from db, create vertices and then draw.
But user will long wait when graph appears.

I'd like to display this graph progressively, level-by-level? i.e. read portion of data from db - add to the graph, draw, read the next nodes etc..

Is it possible?

Thank you.
Nov 20, 2014 at 12:05 AM

displaying the graph progressively will include (as you too mentioned):
  1. read portion of data from db
  2. add to the graph
  3. draw
  4. start over again
In this way every time you draw the graph (step 3) you have to redraw it all (including the previous added nodes) and in the last step it will take the same time as drawing the entire graph, so you will end up spending more time this way because you will have to redraw the graph several times before the last step.

What you can do is import data in smaller chunks, layout the graph, save it and open a new workbook to import the other chunk of data.

Nov 20, 2014 at 9:19 AM
Thank you.
It is exactly what about I asked.

As I see no chance to have dynamic graph but only static.