On 10 Aug 2006 at 0:06, Adam wrote:

>There are many methods of countering this slowness, and most of them
>are off topic for this list, the usual approach is to replicate the
>data needed so that the clients are not waiting as often, or to use
>some sort of application server or n tier model.
>
>None of these are particularly attractive if you have already designed
>your application. In this case, I would recommend a Terminal Services
>based approach.

I should disagree. The solution with replication does not require
any change in application though some adjustments in DB may be
needed. If you put DB replica at "this" side of internet, all selects
will be run fast.

--
SY, Dimitry Sibiryakov.