Network Performance

[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

[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.

[Al Buchholz]

Re: Network Performance

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

[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

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.

[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.

[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?

[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.

[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,

My Calculated Values
ChangeOrder_Calculated.jpg

Are we talking about same thing?

[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,

Thank you. What does mean of the

Form level calculations.

, Do you mean a field events?

[Stan Mathews]

Re: Network Performance

Dbsum() will be much faster than tablesum().
LookupC(), LookupN(), LookupD(), LookupL() are much faster than lookup().

what is the alternation of field calculation

Form level calculations.

[johnkoh]

Re: Network Performance

Hi all,

I have the network speed problem and assumed it caused by my application, not A5. My Shadow application is too slow to refresh, open a form, acting. I removed and breakdown to several set which had may children table. I also removed the Referential integrity.

Even I did those fixing, It is too slow to use my Shadow application on Network. It seems to be working fine on the server computer but still too slow on Client site.

Tom,
When you said

We have also broken our applications up int logical pieces

Is it like this structure?
c:\MyDB\Account\ table_1 ,
c:\MyDB\Account\ table_2,
c:\MyDB\Account\ table_3,
c:\MyDB\Project\ table_A,
c:\MyDB\Project\ table_B,
c:\MyDB\Project\ table_C,

Does this structure increase the network speed?

After I read the Ira's suggestion and his WEB site, I replaced a few button scripts then It seems like it improved the speed to open a form.
However, before I go through all of the forms and scripts, I'd like ask about Using Calculated Values.

Questions
A -- Does the Calculated Values make slow on the forms?
Because I have 5 tables set and 20 Calculated Values, which used the 3 of tablesum(), Lookup(), Some of are used UDF and If( ... if(... if(...)...)... ). This Form is too slow to use and whenever I edit the fields, it is holding too long.
B -- If it makes too slow, what is the alternation of field calculation?
C -- Is there any other fact, something like get a new Network server computer and server O/S?
D -- I want to run it with average speed right now. What do I have to do?

Thank you

[csda1]

Re: Network Performance

Hi Steven,

With dbf's files no processing is done on the server, with fast drives and network throughput, what impact does the server power have?

That's not correct.

Read my tips on record locking here. Basically, how fast the server can process the multiple lock requests, do drive seeks (all over the drive for different data requests), and move sector data back and forth to the hard drive is what the server is doing and is all relevant. The weakest link in the chain is typically the network, but there are also issues of latency that a faster server can minimize it's contribution.


The client station then works with the data.