Jump to content

FileMaker and WAN systems


Jalz

This topic is 6459 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Does anyone use FileMaker as a WAN based solution? I've developed a solution with 4 files, interface, reports, data and an Accounts file. Im using FileMaker Server 8.0v4 with a Cable connection to host my files with a download connection of 1MB and upload of 128Mb/256Mb ( I think its at the lower end).

The data.fp7 file contains 12 tables, and each table contains about 2,500 records. Everytime I open up say the clients TO in my interface file, I tend to do a sort on company_name field in ascending order. The company_name field is indexed, but the sort seems to take an absolute age on a remote computer connecting using WAN. I though with the advent of Server 8.0v3 + sorts were a server based task.

Anyone know how I can improve on the sorting script to get performance upto speed - I think the rest of the application is working at an acceptable speed, its just the sorts that seem to be taking an age. Im going to see if I can test on a faster speed connection to see if this makes a difference.

Many Thanks for your help.

Link to comment
Share on other sites

Well considering that you supposed WAN bandwidth is approximately 10% of a 10BT LAN, I'm not surprised that the sort is slow. Are subsequent sorts slow as well?

If the sort is done on an indexed field, it occurs at the server. But the results still have to go down to the client.

Steven

Link to comment
Share on other sites

This topic is 6459 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.