At 12:08 PM 3/23/2009, Marc Shluter wrote:
What are the best settings for speed using V8 on a small network?
Marc, In addition to STATICDB ON, FASTLOCK ON, make sure to keep the default "SCRATCH TMP" settings in RBENGINE8.CFG file. A properly designed and normalized database with correctly implemented constraints, such as PRIMARY KEY, FOREIGN KEY, PRIMARY KEY REFERENCED, and NOT NULL should also help improve the speed. In a multi-table one-to-many form, make sure that all involved tables are properly listed in order of table relation. Every column involved in a "WHERE colname =" clause should be INDEXed accordingly. Every joining/linked column(s) involved in a "VIEW" should be INDEXed accordingly. Tip: When upgrading/converting to R:BASE Turbo V-8 for Windows, make sure to re-build the entire database, as strongly suggested in Getting Started Guide. Additional Resources: From The Edge: http://www.razzak.com/fte/ . Gaining Speed with Programming . Database Maintenance . Problem Solving in R:BASE Very Best R:egards, Razzak.
