PearlGI
Registered User.
- Local time
- Today, 15:19
- Joined
- Aug 30, 2001
- Messages
- 125
I've been trying to improve a databases performance when run across a network and have identified the following that is causing part of the under-performance issue.
This code extracts field properties from one table in the BE and adds the data to a new table in the FE (no comments re bloating please ).
The line that causes the slow performance is fld.Required (takes around 3 secs for this one line to execute).
Does anyone know why trying to interrogate the TableDef.Field.Required property takes an inordinate amount of time when FE/BE runs over a network when other TableDef.Field properties demonstrate no such issue. No such performance issue when run locally.
Objects
td=TableDef
fld=Field
This code extracts field properties from one table in the BE and adds the data to a new table in the FE (no comments re bloating please ).
The line that causes the slow performance is fld.Required (takes around 3 secs for this one line to execute).
Does anyone know why trying to interrogate the TableDef.Field.Required property takes an inordinate amount of time when FE/BE runs over a network when other TableDef.Field properties demonstrate no such issue. No such performance issue when run locally.
PHP:
For Each fld In td.Fields
rsTemp.AddNew
rsTemp!Field = fld.Name
rsTemp!Type = GetType(fld.Type)
rsTemp!Size = fld.Size
rsTemp!Required = fld.Required <--- this line takes 3 secs to execute
rsTemp.Update
Next
Objects
td=TableDef
fld=Field