slow replace execution

[Cortical]

FMS 9 on winXP, local FM9v3, adv on Mac OS X.4.11

In the process of investigating some performance issues, I have a simple test file, one table with two fields, 40000 records, with a script to do a simple replace (number field, replace with value 1).

When logged in from my Mac, via ssh/open remote/ fmnet, the replace takes 4:30 minutes to process 1000 records. Similar performance is had from a RDC/terminal services client.

The same script when run from a FMSRV schedule; does 40,000 records in 10 seconds

Any ideas on what may be causing this?

Any ideas on what may be causing this substantial difference?

[Vaughan]

"The same script when run from a FMSRV schedule; does 40,000 records in 10 seconds"

So it takes longer when the script is run on a computer other than the server? That sounds like network performance to me.

[Steven H. Blackwell]

When logged in from my Mac, via ssh/open remote/ fmnet, the replace takes 4:30 minutes to process 1000 records. Similar performance is had from a RDC/terminal services client.

What happens when you access the hosted file from FileMaker pro client in the normally configured fashion? Do you still get these delays?

Steven

[Søren Dyhr]

with a script to do a simple replace (number field, replace with value 1).

Tagging is usually a sign of a poorly structured solution, putting "ones" in 40000 records seems a little redundant to say the least.

Normalization aims at as little synchronization as posible!!! it makes me wonder if not some of the methods here could be better utilization of the resources availiable:

http://www.filemakerpros.com/GetNthRecordTAIL.zip

--sd

[IdealData]

Is this an interface problem?

AFAIK when FMServer runs scripts there is no visual interface at all, however FMP client MUST have a visual and the replace function requires that the field is on the current layout.

Try the Freeze Window command before the Replace - it's worked for me before.

Alternatively the SetField script step (in a loop) doesn't require the field on the layout, although looping scripts are inherently slower.

[Steven H. Blackwell]

the replace function requires that the field is on the current layout.

This is not correct. This was changed several versions ago. Also, server side scripts in FileMaker Server 9 are the Web compatible ones only.

Steven

[Cortical]

what happens when connected from a client 'in a normally configured fashion'

I assume you mean terminal services in absentia. Have not been able to try that , but take your point; it is an obvious yardstick. Will endeavour to do.

As Vaughan suggested, it does point to to a network issue (not my area at all). Although I am now reasonably convinced it also has to do with processing data on the client. Looking at Net Monitor, the traffic shows a very clear and prolonged upload block during a simple replace on 1000 via ssh/fmnet from my FM9ADV, wheras the same replace run ssh/RDC/TS/FM9 is a higher, but very much shorter spike.

[Cortical]

Soren:

'In the process of investigating some performance issues, I have a simple test file, one table with two fields, 40000 records, with a script to do a simple replace (number field, replace with value 1)'

[Steven H. Blackwell]

OK, the idea here is not to be doing SSH, Terminal Services, or whatever else. Simply make a connection from FileMaker Pro client to FileMaker Server. This is the way WAN based access is intended to work. Port 5003 needs to be enabled and open for this.

When doing this, how is the perrformance?

Steven

[Cortical]

I work almost exclusively remotely. I am organising a site visit. Will get back in the next few days.

[Søren Dyhr]

There have been opened a new thread with tagging as principle!

http://www.fmforums.com/forum/showtopic.php?tid/191906/post/275746/#275746

--sd

[Cortical]

finally got in there yesterday: 37 secs to replace on 25000 records; just a simple single table 2 field test db