07-29-2003, 12:02 PM
When we want to develop a software program, first, we have to know what are the program specifications,
what we are the functionalities, the project feasibility study/initial spec...then after that come to which technology to use for creating the program.
Just assume that now I want to create a program which the main function is used for manipulating (Analyst)
6000 thousands of records, and I only can use Visual Basic or ASP (web-base) to create, may I know which is the best to go?? and why??
is there any different in term of performance??
In a web-application using ASP, you only have "thin client" users. So the client doesn't need to have anything on there machine but a browser and a connection to the server.
If you create a VB-app, how will you then distribute it/make it available ? Or are you only planning on running it of one server in an intranet or so? As soon as you want to run it off more then 1 machine, the client-server approach is better (else you'll have update and distribution nightmares + older version will surely popp up after a given period of time etc )
About performance --> if you're app is developped right, this wount be an issue. Using client-server will of coarse have a small extra load cause you need the parsing in the webserver, but i'm quite sure my ASP-MySQL app would deliver just as fast as your VB-MsServer (or what you have in mind), and if you'd have more then 200 simultanious users, it would be noticably faster.
But, make sure that all operations that can be done by the db (filtering, counts, aggregations (sums, averages, ...)) are done by the db. And if there are complex algorythms involved, and you use a db that has stored procedures, then you should concider working with stored procedures instead of doing the processing in your ASP.
So i'd think doing it client-server cause it gives you more freedom and future possibilitys, without any real disadvantages. I mean, what are the advantages of doing it in VB ?
07-30-2003, 03:52 AM
with these two statement:
About performance --> if you're app is developped right, this wount be an issue.
So i'd think doing it client-server cause it gives you more freedom and future possibilitys, without any real disadvantages.
I have already known which I should go to--> Web Base in ASP....this is the answer that I want from my post.
Actually, the program I'm going to create is a very simple program, which only require to generate ONE report (One Format) base on the data that user "pump" in, there are only 5 users will be using it and they only will use it once a week. The raw data is in "Excel" format. Due to the raw data have around 6000 records, so I might worry that Web Base application might have problem in term of speed performance.