Network - Running A Standalone Application From A Network Server
stephenREVOLUTION at barncard.com
Fri Dec 17 11:25:18 CST 2004
"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.
>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
>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
>I hope all this makes sense.
More information about the use-livecode