P
Paul Haboeck
Hallo
I have the problem, that the performance between a 'normal SQL user' (=
verry slow) and 'sa' (normal performance) is verry different.
I open a form in my ADE Project an all data in this form are transfered vom
SQL Server to ADE. The data are produced by a stored procedure.
Then I move from one record to the next (visible) record in the form:
sa: no data transfer from SQL Server (shown in SQL Profiler)
normal user: a lot of reads happens (shown in SQL Profiler)
why is the access to the SQL Server different for 'sa' and 'normal user'?
Thanks for answers
Paul
I have the problem, that the performance between a 'normal SQL user' (=
verry slow) and 'sa' (normal performance) is verry different.
I open a form in my ADE Project an all data in this form are transfered vom
SQL Server to ADE. The data are produced by a stored procedure.
Then I move from one record to the next (visible) record in the form:
sa: no data transfer from SQL Server (shown in SQL Profiler)
normal user: a lot of reads happens (shown in SQL Profiler)
why is the access to the SQL Server different for 'sa' and 'normal user'?
Thanks for answers
Paul