Re: need insights :where to go 3 tierd or client server
I meant host based software. ie you log into the unix system with x or telnet and then run the apps on the host. Peter grace [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/26/01 09:55 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Re: need insights :where to go 3 tierd or client server wat do you mean by host connection? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 9:20 PM Let me try and give some ideas Firstly 3-tier is very good if you take the time to firstly understand what it is about and why you use it. On the server with the db you have all of the constraint logic to manage the data integrity On the middle tier you have all business logic for the system and on the third tier or client you have the simple data logic like checking that you only enter a date in a date field on the form. Also if you app has not been designed to be like the above then you need to go back and redesign or you wont gain anything out of 3-tier You probably want to have a network health check to find out what other traffic is on your network. If previously you had only host connections then you almost certainly have a network issue. You might need to have a look at the performance of both the app server and the db server to see what performance figures you have. HTH Peter At 08:25 PM 25/09/2001, you wrote: gurus, Need your advice. i'm trying to migrate our system to oracle using 3 tierd. but we're experiencing a very slow response time 2 sec calling the form + 2sec itspopulating the queries = 4sec (total) compared to our original system w/c is less than a second . many network problems also arises w/c we didn't encounter before. is it wise to go 3 tierd or client server? what are the advantanges and disadvantages of going 3 tierd or client server? Oracle eats lot of resources and very expensive. It seems that going oracle is wrong choice. wat kind of network/resources does oracle need? is netscape a better choice than internet explorer when using oracle? thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter McLarty INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
Re: need insights :where to go 3 tierd or client server
Let me try and give some ideas Firstly 3-tier is very good if you take the time to firstly understand what it is about and why you use it. On the server with the db you have all of the constraint logic to manage the data integrity On the middle tier you have all business logic for the system and on the third tier or client you have the simple data logic like checking that you only enter a date in a date field on the form. Also if you app has not been designed to be like the above then you need to go back and redesign or you wont gain anything out of 3-tier You probably want to have a network health check to find out what other traffic is on your network. If previously you had only host connections then you almost certainly have a network issue. You might need to have a look at the performance of both the app server and the db server to see what performance figures you have. HTH Peter At 08:25 PM 25/09/2001, you wrote: gurus, Need your advice. i'm trying to migrate our system to oracle using 3 tierd. but we're experiencing a very slow response time 2 sec calling the form + 2sec itspopulating the queries = 4sec (total) compared to our original system w/c is less than a second . many network problems also arises w/c we didn't encounter before. is it wise to go 3 tierd or client server? what are the advantanges and disadvantages of going 3 tierd or client server? Oracle eats lot of resources and very expensive. It seems that going oracle is wrong choice. wat kind of network/resources does oracle need? is netscape a better choice than internet explorer when using oracle? thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter McLarty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: need insights :where to go 3 tierd or client server
wat do you mean by host connection? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 9:20 PM Let me try and give some ideas Firstly 3-tier is very good if you take the time to firstly understand what it is about and why you use it. On the server with the db you have all of the constraint logic to manage the data integrity On the middle tier you have all business logic for the system and on the third tier or client you have the simple data logic like checking that you only enter a date in a date field on the form. Also if you app has not been designed to be like the above then you need to go back and redesign or you wont gain anything out of 3-tier You probably want to have a network health check to find out what other traffic is on your network. If previously you had only host connections then you almost certainly have a network issue. You might need to have a look at the performance of both the app server and the db server to see what performance figures you have. HTH Peter At 08:25 PM 25/09/2001, you wrote: gurus, Need your advice. i'm trying to migrate our system to oracle using 3 tierd. but we're experiencing a very slow response time 2 sec calling the form + 2sec itspopulating the queries = 4sec (total) compared to our original system w/c is less than a second . many network problems also arises w/c we didn't encounter before. is it wise to go 3 tierd or client server? what are the advantanges and disadvantages of going 3 tierd or client server? Oracle eats lot of resources and very expensive. It seems that going oracle is wrong choice. wat kind of network/resources does oracle need? is netscape a better choice than internet explorer when using oracle? thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter McLarty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
