Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread EDB C/S vv MiddleTier local EDB
Thu, Jan 17 2008 8:11 AMPermanent Link

"Harry de Boer"
LS

In terms of speed: Is it possible that a middle-tier product connected to a
'local' EDB database (local session but not the same network) is faster then
EDB C/S without a middletier? What can be the reason: faster transports
or...? Or is EDB/ C/S always faster without middletier? Or the other way
around?

Any insights would be appreciated.

Regards, Harry

Thu, Jan 17 2008 8:55 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Harry,

<< In terms of speed: Is it possible that a middle-tier product connected to
a 'local' EDB database (local session but not the same network) is faster
then EDB C/S without a middletier? What can be the reason: faster transports
or...? Or is EDB/ C/S always faster without middletier? Or the other way
around? >>

It depends upon what your needs are.  If you can get by with a disconnected
model, then a multi-tier architecture may be faster since you're working
locally most of the time except when you're synching back up with the main
database.   However, if you're working in a connected model, then you won't
be able to match native EDB for making sure that you're seeing current data
and that the behavior is the same regardless of whether the application is
using a local or remote session.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Jan 17 2008 11:45 AMPermanent Link

"Harry de Boer"
Tim,

Thanks for the information. I think/hope I understand what you're saying.
One more -specific- question though: how about getting results back from a
query (request to the middleware server over IP  -the middleware server on
the same machine as the datat): can it be that a middletier speeds things up
(faster transports maybe) or is EDB C/S faster because you're already
connected?

Regards, Harry



"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht
news:94EFCBA9-2ED0-40F9-95A6-11FC0E902749@news.elevatesoft.com...
> Harry,
>
> << In terms of speed: Is it possible that a middle-tier product connected
to
> a 'local' EDB database (local session but not the same network) is faster
> then EDB C/S without a middletier? What can be the reason: faster
transports
> or...? Or is EDB/ C/S always faster without middletier? Or the other way
> around? >>
>
> It depends upon what your needs are.  If you can get by with a
disconnected
> model, then a multi-tier architecture may be faster since you're working
> locally most of the time except when you're synching back up with the main
> database.   However, if you're working in a connected model, then you
won't
> be able to match native EDB for making sure that you're seeing current
data
> and that the behavior is the same regardless of whether the application is
> using a local or remote session.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Thu, Jan 17 2008 2:23 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Harry,

<< Thanks for the information. I think/hope I understand what you're saying.
One more -specific- question though: how about getting results back from a
query (request to the middleware server over IP  -the middleware server on
the same machine as the datat): can it be that a middletier speeds things up
(faster transports maybe) or is EDB C/S faster because you're already
connected? >>

I doubt if there's any major difference in the transport performance.  EDB's
transport layer is pretty simple and straightforward, and is pretty fast.
If you have to constantly connnect/disconnect with a stateless connection,
then a stateful connection like EDB has will certainly be faster over a
series of queries.  The issue really comes down to what you'll be doing with
the query results, and whether you'll always need the entire result set or
not.   By default, EDB always works on the basis of just sending exactly
what is needed, nothing more and nothing less.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image