Jump to content

Access speed to FMP5 db over dial up


RAP
 Share

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

Recommended Posts

  • Newbies

I'm interested in serving a FMP5 database over TCP/IP and am experiencing very slow response rates. I'm seeking ways to achieve acceptable speeds.

Server: Mac G3, FMP5 dbase file, served over 128 kbps ISDN line, static address, via AppleShareIP

Remote Users: with FMP5 stand alone application opening the served dbase over dial up modem connection (effective speeds of 28.8 - 31.6 kbps); connecting to the database via AppleShare as if it were a local Mac

My tests give me 36.5 seconds to open the dbase, 52 sec to open the form layout and 6 sec to view as List. Over the LAN, these same actions take 4.2 sec, 3.1 sec and 1 sec, respectively.

Other than serving the dbase via the web, is there another way to serve this database in a faster way?

Richard

Link to comment
Share on other sites

TCP will be faster, than AppleShare. Depends on Networking version and setup.

But I would not recommend going under 64k connection.

The only faster way is to open local databases with design and scripts and get just the data from shared database.

Link to comment
Share on other sites

  • Newbies

quote:

Originally posted by Anatoli:

TCP will be faster, than AppleShare. Depends on Networking version and setup.

But I would not recommend going under 64k connection.

The only faster way is to open local databases with design and scripts and get just the data from shared database.

Link to comment
Share on other sites

  • Newbies

quote:

Originally posted by Anatoli:

[qb]TCP will be faster, than AppleShare. Depends on Networking version and setup.

But I would not recommend going under 64k connection.

The only faster way is to open local databases with design and scripts and get just the data from shared database.

[/QB]

Link to comment
Share on other sites

Design 1 database with fields, layouts, graphic etc.

In second database use no graphic and try both on your connection.

Change fields in the "nice" graphic database to hold values from the plain database -- you have nice db with fast connection to the second (remote) db.

Put on your first database related fields from second db.

By all possible combination you will find solution to your speed problems. You can call that "distributed database system".

Do you get the idea?

Link to comment
Share on other sites

This topic is 7452 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
 Share

×
×
  • Create New...

Important Information

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