Re: ADO over WAN
- From: "Eddie Shipman" <mr_delphi_developer@xxxxxxxxxxxxxxx>
- Date: 22 Jan 2007 13:44:08 -0800
Morten wrote:
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
"Arnie" <NoOne@xxxxxxxx> wrote in message
news:45b51c4f@xxxxxxxxxxxxxxxxxxxxxxxxx >"Morten" <na@xxxxxx> wrote
in message news:45b4faa5$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Has anyone successfully run a client/server application connected
to a SQL Server over WAN with good performance?
Yes.
Over LAN environment our query takes
4 seconds, but over WAN it takes about 3 minutes. Of course, this
could be a physical limitation, but I am curious if it's even
possible to make this work.
Morten
I't really a function of much data is being returned to the client.
If you're using a table component, all of the table data will be
shipped to the client. If you're using a query component with a
client-side cursor, the entire result set will be shipped to the
client.
I do some of my development at home over a VPN. While it's
noticeably slower, it works pretty well. However, it's not
advisable to "SELECT * FROM MyTable" when MyTable has 20,000,000
rows ;-)
- Arnie
Returning a recordcount would have to count every record, DUH.
But have you thought of using views? They significantly cutdown
overhead.
--
.
- References:
- ADO over WAN
- From: Morten
- Re: ADO over WAN
- From: Arnie
- Re: ADO over WAN
- From: Morten
- ADO over WAN
- Prev by Date: Re: Need Help with connecting to a database
- Next by Date: "cannot perform this operation on a closed dataset"
- Previous by thread: Re: ADO over WAN
- Next by thread: Re: ADO over WAN
- Index(es):
Relevant Pages
|
