Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General Discussion » View Thread |
Messages 1 to 4 of 4 total |
EDB C/S vv MiddleTier local EDB |
Thu, Jan 17 2008 8:11 AM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |