Are there any quick tips out there on ways to make sure one's database is running at top speeds?
Search for "performance" here, and you'll find a few
but it's usually case by case, especially if you try to do something "fancy"
> Are there any quick tips out there on ways to make sure one's database is running at top speeds?
It's a complex equation of design, deployment (server, clients and network) and user load...
It takes a bit of coding, but once you got the hang of it, FMBench detective can show you step by step performamce on script steps.
Have a look at http://fmbench.com
Execute all your scripts on a blank layout (without anything), in form view, with freeze. Switching to a blanck layout is the best speed tip I ever got.
and for searches, always perform search on indexed fileds first, and then narrow down with a contsrained search. Don't mix unindexed fields with indexed ones in a search.
I would recommend avoiding searching on unindexed fields EVER.
It may at times take some outside our normal thinking to get the best approach...but it can usually be done. A looping script with a find can often perform better than a find on an unindexed field.
Hi Joshua, can you elaborate on "A looping script with a find " as a search unindexed fiel replacement ?
Retrieving data ...