Re: ADO over WAN

"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


.

Relevant Pages

  • lame server messages in named.log
    ... Mar 30 05:42:30.526 security: info: client 202.52.250.176#1052: ... query (cache) denied ...
    (RedHat)
  • lame server messages in named.log
    ... Mar 30 05:42:30.526 security: info: client 202.52.250.176#1052: ... query (cache) denied ...
    (RedHat)
  • Re: High CPU in client (Excel, OWC, Proclarity, etc.) accessing Analysis Services
    ... We have encountered similar problems not limited to Excel, but every client. ... occur when there are many dimensions nested on each other on a single axis ... > Performance Guide to optimize the query, the cube, the server, etc. ... > While the query was grinding, the server was doing absolutely nothing. ...
    (microsoft.public.sqlserver.olap)
  • Re: Delete Query Does Not
    ... When I try to run the SQL query below it gives me the ... Cannot group on fields selected with '*' (client) ... INNER JOIN meals ... Tom Ellison ...
    (microsoft.public.access.queries)
  • Re: Report filtered on a calculated field
    ... Make a query to determine who owes you. ... make this into a Totals Query. ... now you can base your first report directly on this query. ... totals for each client, also define a Client footer section as well. ...
    (microsoft.public.access.reports)