If your databases are running slower than you think they should, here are a few things to think about that might slow the run time of ExtendSim databases:
- String to number or number to string conversions. For example, writing or reading numbers from a string field can sometimes slow the database.
- Using Record ID fields to search for a record.*
- Writing to child fields as it needs to see if the parent value exists.*
- Linked data and Link Alert messages.
* Upgrade to ExtendSim 2024 as its enhancements may help speed this up.