 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
VB Forum / Database Access / March 2007vbUseServer much slower then vbUseClient?
Hi I'm selecting 5 rows from a view. When I fetch the results with CursorLocation set to vbUseClient i get the response in one second. When I use vbUseServer I wait about 1 minute. Can anyone explain this behaviour to me? Thx J ¤ Hi ¤ ¤ I'm selecting 5 rows from a view. When I fetch the results with ¤ CursorLocation set to vbUseClient i get the response in one second. ¤ When I use vbUseServer I wait about 1 minute. Can anyone explain this ¤ behaviour to me? Unless you're using a server-side forward-only read-only cursor there are typically multiple round trips to the database to fetch each row of data when using a server-side cursor. Client-side cursors only require a single call. Paul ~~~~ Microsoft MVP (Visual Basic) On 27 Mar, 14:40, Paul Clement <UseAdddressAtEndofMess...@swspectrum.com> wrote: > ¤ Hi > ¤ [quoted text clipped - 10 lines] > ~~~~ > Microsoft MVP (Visual Basic) Right - but I'm only selecting 5 rows - shouldn't server-side cursor be only unnoticeably slower? J ¤ > ¤ Hi ¤ > ¤ ¤ > ¤ I'm selecting 5 rows from a view. When I fetch the results with ¤ > ¤ CursorLocation set to vbUseClient i get the response in one second. ¤ > ¤ When I use vbUseServer I wait about 1 minute. Can anyone explain this ¤ > ¤ behaviour to me? ¤ > ¤ > Unless you're using a server-side forward-only read-only cursor there are typically multiple round ¤ > trips to the database to fetch each row of data when using a server-side cursor. Client-side cursors ¤ > only require a single call. ¤ > ¤ > Paul ¤ > ~~~~ ¤ > Microsoft MVP (Visual Basic) ¤ ¤ Right - but I'm only selecting 5 rows - shouldn't server-side cursor ¤ be only unnoticeably slower? I wouldn't expect it to take a full minute for five rows, no. You didn't mention what type of database you are working with but this could be an issue with the driver or provider for your database. Paul ~~~~ Microsoft MVP (Visual Basic) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.