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

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.

HTH

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

RE: An ASDL line is at most 1.5 megabits

I have the DSL with 1.5Mb download and only 128k-upload speed. Is the ADSL any better?

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.

You can ask you ISP about sdsl. It is the same speed download and upload.

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.