Re: ADO over WAN

From: "Arnie" <NoOne@xxxxxxxx>
Date: Tue, 23 Jan 2007 10:08:15 -0500

"Morten" <na@xxxxxx> wrote in message
news:45b522b6$1@xxxxxxxxxxxxxxxxxxxxxxxxx

Thanks for your input.
We are using server-side cursors on the bigger datasets (actually, the
dataset is over 10,000 records), but even the smaller queries returning
less than 10 records have the same performance problem. Just returning a
recordcount takes forever. Any ideas?
Morten

Brian asked a pertinent question below. Is the same physical box and DB
used in both the LAN and WAN scenario?

Another fairly obvious question is what is the speed of the WAN? T1 or
better? Two cans and a string?

What do you get if you ping the DB server from the client?

- Arnie

.

References:
- ADO over WAN
  - From: Morten
- Re: ADO over WAN
  - From: Arnie
- Re: ADO over WAN
  - From: Morten

Prev by Date: Re: "cannot perform this operation on a closed dataset"
Next by Date: Re: ADO over WAN
Previous by thread: Re: ADO over WAN
Next by thread: Re: ADO over WAN
Index(es):
- Date
- Thread

Relevant Pages

Re: ADO over WAN
... We are using server-side cursors on the bigger datasets (actually, ... I't really a function of much data is being returned to the client. ... If you're using a query component with a ...
(borland.public.delphi.database.ado)
Re: ADO over WAN
... We are using server-side cursors on the bigger datasets (actually, ... I't really a function of much data is being returned to the client. ... If you're using a query component with a client-side cursor, ...
(borland.public.delphi.database.ado)