Performance recommendations
- Evaluate if your target projects are well suited to these technologies.
In general, projects that are read-intensive and require disconnected data
are good candidates.
- Limit the number of tables in the metadata. One or two is best because
relationships, with respect to filters, become ambiguous when graphs have
many branches.
- Work with small data sets as often as possible to avoid consuming excessive
amounts of memory within your applications. You can limit the amount of data
returned to the SDO by specifying filters in the metadata objects or by using
paging.
- For Web applications, if the DataGraph is not too large and is to be
reused later, store it in the user session.