Add cache for default values
FillFieldsDefaultValues (in TCustomDADataSet.DataEvent) procedure is called everytime for a dataset, if Options.DefaultValues is True. It creates a query to get the default values. It might be a good idea to cache the defaults and avoid the query.
-
Anonymous commented
We have runtime static Database structure, so it never changes. All client apps are connected to same database. So Caching default values on database basis would speed up thins, and also remove stress from the server.
Server will see quite many queries per day, even they are very fast queries, for exact same static data. In Our case.
This should be optional for sure.