Visual DBase program over network

[n8jbrown]

I am having a rough time with a Visual Dbase program running across a Windows XP P2P TCP/IP network. Program runs local withoutt a hitch. It's extremely fast. Try to access the data across the network, and it crawls. ANy help or ideas would be greatly appreciated. Lemme know if I left out any needed details.

 

[dearingkr]

I've seen this before. It is usually due to the size of the database.

The way I fixed the problem was to write a separate front-end program installed on the client PC so that the only traffic you get accross the network is the data transactions.

 

[OPTIS]

I have used dbase for years and am also experiencing dificulties with slow networking under xp. It works much faster with ipx/spx than tcp/ip, but it is still slower than under windows 98 or 95. If there is a "front end" program to speed things up, would you be willing to share it with me?

Thanks

 

[bierhunter]

A problem with most p2p database apps is that the entire database is often pulled across the network and then accessed on the client. As the database grows, it gets slower and slower due to increasing size. Many people I've worked with have throught that just storing a DB file on a server makes it act like a client/server database. Nope. Same problem. The client is doing all of the work.

If you don't have a client/server type database (SQL Server, Oracle, MySQL, etc), I would recommend Dearingkr's solution. Build a front-end app that runs on the server (other machine, etc), and let it parse the DB for you. That way just the resulting data is sent across the network.

Or rewrite the thing to a web-based app.

Mainly, you need to find a way to avoid pulling the entire database across the network.



BierHunter
CNE, MCSE, CCNP