Wrox Programmer Forums
|
Beginning VB 6 For coders who are new to Visual Basic, working in VB version 6 (not .NET).
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 6th, 2006, 10:06 PM
Registered User
 
Join Date: Feb 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Shared EXE

Hi there!

I have a question regarding installation, i have a client/server program where about 40 users using it. i actually installed the main program in the server and just shared the EXE in each workstation.

Will there be a problem in terms of server performance (memory usage, cpu usage, etc.?
or the server works as if the program is installed by each workstation?

Thank you so much!

 
Old February 6th, 2006, 10:19 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 627
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am not sure I understand.
You have a network of computer plus a server, and a main program.
What type of program is it (windows, web, database...), that is, what is the resource that the clients are sharing in the server?
What do you mean "shared the exe"? Is the exe copied in each pc? And if yes, does it connect remotely to the server?

Marco

Marco
 
Old February 7th, 2006, 01:48 AM
Registered User
 
Join Date: Feb 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The scenario is this:
I developed an application using VB6 as front end and MSSQL Server 2000 as my back end. Instead of installing the application in each workstation, what i did was, I Installed the program to the Server and shared the folder containing the application. Then, i made a shortcut to each workstation (client)pointing to the application installed in the server.


so for example, the target of the shorcut icon would be:
\\SERVERNAME\My Application\application.exe

The application is actually running, but what i want to know is, is the approach does'nt effect the server's performance, in terms of memory and cpu usage? or is it much better if i install my application individually to each computer who will use the application?

what would be the disadvantage of just sharing the exe file rather than installing the application to each computer?

Hope it's clear to you...
I hope you can help me..
Thank you!


 
Old February 7th, 2006, 10:33 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

well.. if you're app is working then you dont have a lot of problems...

but think about net usage.. you are loading a program that is outside the pc you are running it, so every time the app paging itself into memory it will use bandwith to read the next part of the program.
also think about the poor disk trying to serve a lot of pc at the same time...
another think i could think of if where did it save temp files? because if running on the server it will do everything on it..

the app you are describing should be a web app or should be installed on every pc.

besides that, if that work, i dont see any problem with it.

HTH

Gonzalo
 
Old February 7th, 2006, 12:08 PM
Registered User
 
Join Date: Jan 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have done this before, what happens is eventhough the exe resides on a server somewhere it will run on the client pc. This means it is using the clients memory, and any reference to App.Path will be to the clients hard drive.

The app will however need to be sent across the network to the requesting client, this could cause issues with bandwidth. You will also need to install any DLLs or OCXs the application uses on each PC that will be using the application. Other than that I found this to be a very convienient way to keep all machines using the application up to date.

 
Old February 7th, 2006, 03:19 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 627
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by AndreK
 I have done this before, what happens is eventhough the exe resides on a server somewhere it will run on the client pc. This means it is using the clients memory, and any reference to App.Path will be to the clients hard drive.
Absolutely true!
What you have done is not a client/server application,is just a program that connects remotely to the database in another computer. And that is perfectly fine... To minimize network access, you should try to perform as many operations as possible using the database itself, so the connection to the "client" is limited to only the data that is needed (for example, do a Select with a Where clause instead of getting all records and sort them in the client)
Marco
 
Old February 7th, 2006, 09:31 PM
Registered User
 
Join Date: Feb 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you so much for your help guys...
Well atleast now i know...

I hope i could you also soon...






Similar Threads
Thread Thread Starter Forum Replies Last Post
Membership: aspnet_sql.exe -> aspnet_regsql.exe ricpue BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 2 August 9th, 2006 11:40 PM
problem creating .exe from MFC AppWizard(exe) c++ method Visual C++ 0 July 7th, 2006 03:28 AM
PHP5 and php.exe php-cgi.exe php-win.exe freddo Beginning PHP 1 August 16th, 2004 09:28 AM
VB Exe triggering another EXE moiyed Beginning VB 6 2 November 6th, 2003 11:48 PM
Spawning a VB EXE from another EXE alantkilzer VB How-To 3 July 30th, 2003 07:59 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.