I am very interested in Graph data modelling and with the Graph capabilities in OpenNTF Domino API I decided to setup some demo environments just to get my head around the subject and how you can implement it in XPages and use Notes data.
To my opinion reading Notes data in the Graph database structure can bring interesting new opportunities, far beyond what we can deliver with Views and Collections today.
Oliver Busse has provided a great starting point with his SUTOL demo application so I started with that one.
Besides the implementation and Graph capabilities I am also curious about performance. So I run some tests on my working demo app. With the help with a simple agent I decided to be gentle and create a set of only 20.000 user documents.
The first test was about returning user profiles (nodes) matching certain properties (relations), presented in a repeat control. Below the list the time to load the filtered set is displayed.
When I compare the result with a normal view filter (by category or FT search) the results where a bit disappointing.
I also noted that navigating through the list was very slow (20 seconds or more returning a new set of rows of 10 documents). More than I expected I received timeouts.
The reason for this performance is still unknown. I guess there is no index created yet for the user node in the graph db structure. Why navigating through the list is so latent in performance is also a mysterie.
Nevertheless, my demo is up and running so expect more results on Graph in XPages with Notes data in the future on this blog.
Below are sampels of performance using the “traditional” FT search filter capacity in Notes. Notice the difference.
I would like to thank Oliver Busse for his guidance getting the demo app up and running and for explaining some basic concepts of the implementation.