Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Performance on remote queries |
Mon, Sep 19 2011 1:28 PM | Permanent Link |
Stefano Monterisi | HI, Tim,
I have poor performance when open queries from remote (internet) server in this scenario: 1 Master table and 3 detail queries. When I scroll master and open the 3 detail queries (few record foreach) I have 3 separate request and answer to and from server (detail1.open; detai2.open; detail3.open) with a long time. There is a way to perform one request and one answer from remote for all 3 queries? (Anydac have a similar approach for performance boost). Or a workaround for better master-detail remote performance? Thanks in advance, Stefano Monterisi |
Tue, Sep 20 2011 11:18 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Stefano,
<< I have poor performance when open queries from remote (internet) server in this scenario: 1 Master table and 3 detail queries. When I scroll master and open the 3 detail queries (few record foreach) I have 3 separate request and answer to and from server (detail1.open; detai2.open; detail3.open) with a long time. There is a way to perform one request and one answer from remote for all 3 queries? (Anydac have a similar approach for performance boost). Or a workaround for better master-detail remote performance? >> Do you have any lookup fields or calculated fields defined for any of the tables ? EDB will, by default, read enough rows to fill any attached grids, so the detail queries, by themselves, should not be an issue. Also, you can use the TEDBSession.OnRemoteTrace event handler to analyze what is occurring when you complete the mentioned operations: http://www.elevatesoft.com/manual?action=viewevent&id=edb2&product=d&version=7&comp=TEDBSession&event=OnRemoteTrace You can just put a special form with a TMemo in your application, and then dump out the trace events to the TMemo in real time. When you're done analyzing, just hide the form in your application. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Sep 20 2011 12:55 PM | Permanent Link |
Stefano Monterisi | Hi Tim,
I will try and report to you, Thanks. I have already a big problem with Devexpress lookups components that perform remote locate also on display (Arghhh!!): Without, the situation is better, but fetching of 3 remote details (few records with 10-20 fields, sensitive result) remain slow. I try. Thanks, Tim. Stefano Monterisi |
Tue, Sep 20 2011 3:02 PM | Permanent Link |
Terry Swiers | Stefano,
> I will try and report to you, Thanks. I have already a big problem with > Devexpress lookups components that perform remote locate also on display > (Arghhh!!) If I remember right, the lookup components for DevExpress work much faster if you set them to GridMode and set CaseSensitiveSearch to true. Terry Swiers Millennium Software, Inc. http://www.1000years.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |