AnsweredAssumed Answered

Record creation via "push" very slow

Question asked by davehob on Mar 26, 2013

Trying to make an application faster, I've been trying to create records via the "push" method, including a global field as part of the relationship, then using set field to force the creation. But I'm obviously doing something wrong, as the creation is painfully slow - several seconds. I have a table of Sessions (SSN) with related Attendances (ATT) - an Attendance record represents a person (from the PPL table) attending a Session.

 

The "create" relationship is:

 

SSN_g_PPL_ID = ATT_kf_PPL_ID

SSN__kp_ID = ATT_kf_SSN_ID

 

From the context of Sessions, I set the global field (SSN_g_PPL_ID) to the primary key value of the Person. I then do a Set Field of another field in the ATT rec, which forces the creation of the record. It works, but, as I said before, very slowly.

 

If you have any suggestions as to what I'm doing wrong, I'd be very grateful. This is in a data-separated solution, FMPA11, Windows.

 

Dave.

Outcomes