You should probably look into PostgreSQL while you are at it too (www.postgresql.com), it is also open source, but unlike MySQL, is not "open source for non-commercial use" (MySQL has some potential licensing issues), but at the same time, PostgreSQL is quite a bit more powerful than MySQL. I'm developing a commercial product around it, and have been quite happy with it so far.

On Dec 17, 2004, at 12:25 PM, Stephen Barncard wrote:

"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


-----------------------------------------------------------
Frank D. Engel, Jr.  <[EMAIL PROTECTED]>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life.
$




___________________________________________________________
$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com

_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to