Jump to content
Server Maintenance This Week. ×

Calculations running when working remotely


michele

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

Recommended Posts

A customer of mine installed ADSL telephone lines to allow personel to work from home.

Everything runs fine and fast as usual but when opening some databases the database starts calculating (for example the date of today???) and that can take up to ten minutes.

They have a filemaker server and everything runs fine in the office.

What's happening?

Thankyou for reading and eventually answering my question.

Mich

Link to comment
Share on other sites

  • 4 weeks later...

Today functions will recalculate when the table is reopened on a new day. This will be particularly slow over an ASDL line, or any remote hookup actually. Come to think of it, it's pretty slow even if you're sitting right there.

The solution is to never use the Today function, but use the Status(CurrentDate) instead. smile.gif

HTH

Link to comment
Share on other sites

The why of slow operation on remote connections is simple. In your office your network is probably 100BasedT. An ASDL line is at most 1.5 megabits, more likely 768 kilobits or less. To put it another way 0.768BasedT, about 200 times slower than your office connection. To get office performance on a remote connection is about $3,000/mo. per end for a T3 connection. Bandwidth outside your office isn't easy or cheap!

-bd

Link to comment
Share on other sites

  • 2 weeks later...

If you're running FMS then you need to run "Recalculate Today" on a daily basis. Typically early hours of the morning, then the FM "clients" won't get the dalay.

Incidentally, your ADSL connection will only perform as well as the best UPLOAD from the server - this is typically far less than the quoted download. Typical "broadband" in the UK is 512K DOWN and 128K UP.

Link to comment
Share on other sites

  • 2 months later...

If you CableTV provider supports it look into broadband service from them. Although you share a pipe with everyone else in your neighborhood the pipe is GIGANTIC and will usually allow for 1.5mbs up and down. With all flavors of DSL you have your own pipe but it is tiny and eventually combined with everyone else anyway.

Link to comment
Share on other sites

This topic is 7876 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.