Submitted by WayneK on 2022/12/14 15:59

I am repeatedly getting this error message:

Field FileFullName is slow to computer (took 4280 mSec) which affects UI responsiveness.  Consider hiding it in the Properties pane.  (Manage fields>Options>Check both checkboxes for "Hide in xxx').

Both boxes are already checked.  What can I do to make this stop popping up?

Wayne

Comments

Hi Wayne,

In the next version, this will be fixed. Now, 4280 mSec is a long time to evaluate a field value.

  1. How many FileRef, FileName and FilePath values are in your IQBase ? 
  2. I've seen this once, and a database repair fixed it. Have you tried that ?

If you want, you can try to change the source of the field FileFullName. This should give the same result:

SELECT ¯qFileRef.ItemID, [¯fText]![Value] & [¯fText_1]![Value] AS FileFullName
FROM (¯qFileRef LEFT JOIN ¯fText ON ¯qFileRef.ItemID = ¯fText.ItemID) LEFT JOIN ¯fText AS ¯fText_1 ON ¯qFileRef.ItemID = ¯fText_1.ItemID
WHERE (((¯fText.FieldID)=13) AND ((¯fText_1.FieldID)=12));
 

If you don't use the field, you can also simply disable it by changing the source to something very simple. More info available upon request

How do I ?