Looking for experiences using .adp projects over SQL Server 2005

[Dean Slindee]

Within SQL Server 2005 (SP1/SP2) the ability to host .adp projects over a
SQL Server 2005 back-end was made possible.

I have converted a couple of legacy .adp projects from SQL Server 2000
back-end to a SQL Server 2005 back-end. In early A-B testing, one user,
perhaps more, is experiencing very slow response time. The user is running
both the legacy .adp project and the test .adp project on the same box
(Windows 2000 OS). I have watched as the user enters a keystroke into a
text box, and experiences 4-second delay in the echoing back of the
keystroke to the screen. On my own development PC (Vista OS), I can see a
slight slow-down, but not the echo problem.

I am wondering, firstly, whether keystrokes travel across the network and
back before appearing on the form?

Does anyone else have experiences (fast or slow) with regard to migrating
..adp projects to a SQL Server 2005 back-end?
Anyone got advise on where or what steps to proceed along to isolate the
echo problem?

Thanks in advance.
Dean Slindee

 

[Arvin Meyer [MVP]]

Generally keystrokes in both MDBs and ADPs stay on the form until the form
is requeried or closed. However, it may be that the code is saving the
record sooner, or that this particular computer has an issue. My own
experience using XP and a 2003 server running SS 2005 is reasonably quick,
certainly no 4 second delays, not even in Terminal Server apps.

 

[Sylvain Lafontaine]

Within SQL Server 2005 (SP1/SP2) the ability to host .adp projects over a

SQL Server 2005 back-end was made possible.

I have no idea what mean with that sentence or what's your setup.

If you are using Terminal Server then check the status of your TS remote
desktop: does using it bring the slow speed response. Probably that you're
also using a VPN if you are going over the WAN instead of remaining on the
local LAN; so you'd check its status as well.

 

[Sylvain Lafontaine]

Well, this is not new with SQL-Server 2005 and storing data with ADP can be
done using an earlier version of SQL-Server - ie., the 2000 version - or
with or without SP1 or SP2; so his sentence still doesn't mean anything to
me.

Second, I still don't understand at all what is his setup:

1- is he on a LAN or over the WAN?

2- is he using a VPN or not?

3- is he using a Terminal Server remote session or not?

And to that, probably that you can add other possibilities as well, too.