dcsimg
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4

Thread: Slow down execution

  1. #1
    Join Date
    Apr 2005
    Posts
    102

    Slow down execution

    The sound of that makes me cringe, but I have a problem. Basically I am removing records from an access database and loading a listview with the results. The problem is that access is in no hurry, and the record that has been deleted still exists in the table when the procedure is called to load the listview. The only way I can overcome the slowness of access is to run a loop to kill time.
    Last edited by superuser; September 25th, 2005 at 08:57 PM.

  2. #2
    Join Date
    Jun 2004
    Location
    Kashmir, India
    Posts
    6,808

    Re: Slow down execution

    I have a small doubt.
    Are using a recordset to load the Listview and is that recordset opened before you delete the records?

    If yes, then you should consider re-querying the recordsets before you load Listview.

    --if some code is posted that will be really helpful in uderstanding the problem--

  3. #3
    Join Date
    Sep 2005
    Location
    Delhi, INDIA
    Posts
    237

    Re: Slow down execution

    Dear superuser,

    Please use conn.beginTrans and conn.committrans commands before and after your conn.execute syntax.
    I'M BACK AGAIN !!
    -------------------------------------------------------------------------
    enjoy the VB !
    If any post helps you, please rate that.
    Always try to findout the Solutions, instead just discussing the problem and its scope!

  4. #4
    Join Date
    Sep 2005
    Location
    Delhi, INDIA
    Posts
    237

    Re: Slow down execution

    Thanks !!
    I'M BACK AGAIN !!
    -------------------------------------------------------------------------
    enjoy the VB !
    If any post helps you, please rate that.
    Always try to findout the Solutions, instead just discussing the problem and its scope!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)