should i run one instance or many...

[kovan]

i have been working on this project for quite sometime
and damn i am happy that the backbone is done

i dont know what i should do from here
the app connects to one db on the network

should i install the app on EVERY machine
or just throw the exe on the server
and have all machines using that one exe
or should each client have its instances

anyone that can give me cons' n pro's for both that would be great
thanks

here is some pros about having just one exe
that if i update it, i only have to do it to ONE file
and the fact that it depends on an ini which if i change this ini then i only change it once instead of many..

[ShIzO]

i'm not sure if you've used any middle-tier but if you did then i would distribute the application to clients and install/register the DLL on the server. in this case whenever you want to update - you update it in one place(server).


but if you've only 2 tiers then you have a problem, you can put the app on the server and let everybody run it from there but imagine the traffic on your network.

and that's why it is the best to create n-tier application rather than 2-tier.


email me if u have any questions.

[kovan]

well i dont know what you mean by ntier
i am using ado
so i still need to run a setup on each computer to register dlls ect..
but during this installation i will not install the .exe on their machine but then make a shortcut to the .exe thats alrady on the server