The VPRO is handling million of objects, so i wouldn't worry about 30.000 objects.I wondered if anyone has experiences with very large object clouds and performance. We would like to store answers to form questions inside separate nodes, but this has the potential of leading to a very large number of database records. Suppose you have a form with fifteen questions and 2000 replies. This leads to 30000 answer records and just as many relation records (posrel) to relate these answers to the questions.
This puts a lot of pressure on the posrel and insrel tables, which are also used in a lot of other relations. Will MMBase perform sufficiently under these conditions? Does anyone have experience with very large clouds and MMBase performance?
Maybe you would have to put indexes on some fields of your tables, in regard to fast searches.
Rob
