"About a half-dozen use the program.."
John, If this is data you share, and it is shared often, you should immediately investigate using MYSQL to store your data. Not only will it speed up everything when you give everyone their own application to run locally, but its built-in record locking and other features will protect your data and you could even use the centralized data storage for code updates as well -- all scriptable..
MYSQL (and SQL in general) was designed to provide a reliable and fast way to exchange data with terminals and computers with low data rates. Play around with a free SQL browser and a database and type in a few queries to see how easy it works. If one can use filemaker, one can use SQL.
There are versions of MYSQL that are open source and run on many platforms, so find an old piece of iron and get it running -- or check with your ISP, they often have SQL servers included with your service. That's even easier, as you don't have to maintain the server.
sqb
Greetings All,
I have written a standalone estimation package for our company using Revolution. About a half dozen people use the program. We tried putting the app on the company server, but it runs awfully slow. This whole process raises several questions:
1. Can a standalone stack, running on a server, actually be used by more than 1 person at a time without problems?
2. Related Question: When somebody opens this stack on the server. Is it actually running on the stack, or does the program run on the indivual's computer?
3. Related Question: When a person is working on an estimation project, all the values for that project are temporarily stored in various fields within revolution. This info is later saved on a server as a text file. Am I correct in assuming that if more than 1 person is running the app off the server, if indeed this is possible, that it could create quite a mess?
4. Related Question: Since this is a new program, I am coming up with a new version at least twice a week. If having several people running the stack off the server is not possible, is there a way to quickly update the stack on everybody's individual computers with a newer version?
I hope all this makes sense.
Kind regards, John Miller
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
