Welcome, Guest
Username: Password: Remember me
Visual Objects

Please use this forum to post questions about Visual Objects and Vulcan.NET
  • Page:
  • 1

TOPIC:

bBrowser and SQL Server delay question 04 Mar 2022 16:30 #21766

  • Stavros Spanos
  • Stavros Spanos's Avatar
  • Topic Author


  • Posts: 63
  • Hi all!

    We are using a data bounded bBrowser connected with a VO SQLTable that handles a lot of data, code blocks etc.

    When we are moving from row to row (with mouse or keys), it seems that a data refreshing is going on, concerning the current record (actually the records seems to be re-read from original SQL Server when we move to it).

    This of course is very nice, but causes a delay of 2-3 second while we are browsing.

    We have 2 questions:

    • Is there a way to work more asynchronously? We need to browse without any interaction with the server and <Refresh All> when needed. Is there a way to do this?

    • Is there a – kind of – “granularity” concerning thw interaction between SQL Server / SQLTable / bBrowser?? It seems like the problem gets worse with Tables with 50000-100000 rows.

    Thanks in advance!

    Please Log in or Create an account to join the conversation.

    bBrowser and SQL Server delay question 08 Mar 2022 13:19 #21808

    • Joachim Bieler
    • Joachim Bieler's Avatar


  • Posts: 36
  • Hi Stavros,

    the bBrowser uses the methods Skip(), GoTop(), GoBottom() and Goto() from the dataserver for record movements. If data refreshes take place in the dataserver, then the bBrowser has no influence on it. Whether this actually happens, I don't know at the moment.

    Can you please send me a code example how you create the SQL dataserver (SQLSelect or SQLTable or ...). I will then build a test programme to reproduce the behaviour.

    Regards
    Joachim Bieler

    Please Log in or Create an account to join the conversation.

    bBrowser and SQL Server delay question 23 Aug 2022 12:24 #23451

    • Stavros Spanos
    • Stavros Spanos's Avatar
    • Topic Author


  • Posts: 63
  • Thanks for the reply Joachim. I'll open a new thread as we have found some things that might help. I will also include a Youtube Video that shows the problem.

    Please Log in or Create an account to join the conversation.

    • Page:
    • 1