Newbies RAP Posted May 23, 2001 Newbies Posted May 23, 2001 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
Anatoli Posted May 23, 2001 Posted May 23, 2001 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.
Newbies RAP Posted May 24, 2001 Author Newbies Posted May 24, 2001 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.
Newbies RAP Posted May 24, 2001 Author Newbies Posted May 24, 2001 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]
Anatoli Posted May 24, 2001 Posted May 24, 2001 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?
Recommended Posts
This topic is 8584 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 accountSign in
Already have an account? Sign in here.
Sign In Now