The ability to fine tune R:BASE itself is one of the many enhancements added over the years. Most often, R:BASE is able to make the right decisions about the best way to process commands.
You know your data better and could sometimes pick a more efficient method if given the opportunity. The options detailed below can help you reach maximum performance with R:BASE, but since each application and database is a unique set, only a trial and error process identifies which options help in your situation. Do not forget that different hardware configurations and available memory also affect performance. Experiment with the options and see which ones improve performance for your application. You, the developer, have the opportunity to set R:BASE internal parameters to gain optimum performance for each application.
