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

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

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

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