Network Performance

[johnkoh]

Re: Network Performance

Stan,

Thank you. What does mean of the

Form level calculations.

, Do you mean a field events?

[Stan Mathews]

Re: Network Performance

Form calculated fields.

See this.

I may have misread your post. It first seemed you were talking about table calculated fields. If you are using table calculated values presently you will need to use the suggested functions to speed up response time.

[johnkoh]

Re: Network Performance

Stan,

My Calculated Values
ChangeOrder_Calculated.jpg

Are we talking about same thing?

[Stan Mathews]

Re: Network Performance

We're talking about the same thing but the question is where you are you when you create these.

If you open a set in the set editor and use the xy toolbar button you get that editor and the calculations are available when the set is open.

If you open a table with the Restructure Table menu choice and use the xy toolbar button you get that editor and the calculations are available when the table is open alone or when it is the parent of a set (I think).

If you open a form in design mode and use the xy toolbar button you get that editor and the calculations are available when the form is open.

Consider this example using AlphaSports and the interactive window.

cid = "00000019"

? lookup("customer","customer_id = "+quote(cid),"lastname")
= "Jennings            "

? lookupc("F",cid,"lastname","customer","Customer_I")
= "Jennings            "

The lookupC() is much faster since it uses the Customer_I index. You won't notice it in the interactive window for retrieving one value but if used for a calculated value repeatedly, it makes a difference.

[johnkoh]

Re: Network Performance

Stan,

I used it this way "open a form in design mode and use the xy toolbar button"

Is it right location?

I will change and use the DBSUM() and Lookupc() instead of tablesum() and Lookup()

Thank you.

[johnkoh]

Re: Network Performance

Stan,

I had bad experience with Index because whenever I used the pack tables, A5 renamed, and changed my Indexes so It created another headache.

How can I lock my Index?

[Stan Mathews]

Re: Network Performance

You can't lock an index. I've never had Alpha rename or change an index so I can't advise you how to avoid it.

I would strongly advise you to try indexes again. If you are using a lookupC() or similar you can try adding some error checking.

AlphaSports, this works.

on error goto error_handler
cid = "00000019"
rslt = lookupc("F",cid,"lastname","customer","Customer_i")
ui_msg_box("",""+rslt)
end
error_handler:
    err = error_code_get()
    msg = error_text_get(err)
    ui_msg_box("Error", msg)
end

This displays a message saying that the index is missing. I changed the name in the lookupC() to simulate what would happen if Alpha renamed the index or removed it.

on error goto error_handler
cid = "00000019"
rslt = lookupc("F",cid,"lastname","customer","Customer_[COLOR="red"]X[/COLOR]")
ui_msg_box("",""+rslt)
end
error_handler:
    err = error_code_get()
    msg = error_text_get(err)
    ui_msg_box("Error", msg)
end

You could also run INDEXES_MATCH_DEFSTRING() frequently to try to track down the issue.

[Al Buchholz]

Re: Network Performance

I had bad experience with Index because whenever I used the pack tables, A5 renamed, and changed my Indexes so It created another headache.

Keep the index name at 10 characters or less.

[johnkoh]

Re: Network Performance

Stan,

Which UDF is better and faster in the below scripts?

FUNCTION Customer_Add AS c (vCustId as c )
dim tCustom as p
dim qCustom as p
dim nCustom as n
dim vCustAdd as c
tCustom = table.open("customer",FILE_RO_SHARED)
query.order ="customer_id"
query.filter = "customer_id="+quote(vCustId)
qCustom = tCustom.query_create()
nCustom = qCustom.records_get()
    if nCustom>0 then
        vCustAdd = tCustom.Customer_address
    end if
	qCustom.drop()
	tCustom.close()
Customer_Add=alltrim(vCustAdd)	
END FUNCTION

FUNCTION Customer_Add AS c (vCustId as c )
  Customer_Add = LookupC("F",vCustId,"Customer_address","customer","Cstmr_Idu")
END FUNCTION

[Al Buchholz]

Re: Network Performance

Use Ira's tool to measure or look at the Alpha Profiler.

[DaveM]

Re: Network Performance

My Shadow application is too slow to refresh

This would mostly point to a network issue. IE bad card, switch, wireless, someting, etc

"refresh shadow" is mostly a copy operation across your lan.

[johnkoh]

Re: Network Performance

Good Morning,

Al, Thank you for your help.

I tried the Profiler_begin() but the Trace Window did not show the result
What did I missing on this direction?

Profiler_Result.jpg

[Al Buchholz]

Re: Network Performance

You can also put the results in a file...

profiler_end(a5.Get_Path()+chr(92)+"tt_profiler.txt")

This puts the results in a file name tt_profiler.txt in the database directory ( if not shadowed..)

Not sure why the trace window isn't working.

[Stan Mathews]

Re: Network Performance

You should see the results in a Profiler tab of the trace window.

profiler output.gif

[johnkoh]

Re: Network Performance

Stan,

I do not have the "Profiler" tab as you shown. I have the last tab as "c:\dlgstack.log" on the Trace Window.

I also tried the "profiler_end(a5.Get_Path()+chr(92)+"tt_profiler.txt")" from AlphaSports sample, but nothing.