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 <ORACLE-L_at_fatcity.com> 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: mglim_at_softhome.net
> >
> >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: ListGuru_at_fatcity.com (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: peter.mclarty_at_incts.com
>
> 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: ListGuru_at_fatcity.com (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: mglim_at_softhome.net

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: ListGuru_at_fatcity.com (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).