Skip to content

not responding when running large SQL script #1006

Open

Description

@ankushbbbr

Details for the issue

While executing large sql scripts from .sql files, the application goes not responding. This work must be done in a seperate thread, to avoid blocking the UI thread.

Useful extra information

I'm opening this issue because:

  • DB4S is crashing
  • DB4S has a bug
  • DB4S needs a feature
  • DB4S has another problem

I'm using DB4S on:

  • Windows: ( version: ___ )
  • Linux: ( distro: ___ )
  • Mac OS: ( version: ___ )
  • Other: ___

I'm using DB4S version:

  • 3.9.1
  • 3.9.0
  • Other: ___

I have also:

Activity

  1. chrisjlocke commented on May 4, 2017

    @chrisjlocke
    Member

    Unsure how other OS's handle this..... (sorry - just thinking aloud...)

  2. justinclift commented on May 4, 2017

    @justinclift
    Member

    @ankushbbbr Good point, that's probably a decent idea we should implement. 😄

    @MKleusberg ?

    @ankushbbbr As a thought, since you're using a really old version of our program, would you be ok trying one of our latest nightly builds and let us know if the problem still seems the same?

    If so, they're here (pick either the 32 or 64 bit one as needed):

  3. ankushbbbr commented on May 4, 2017

    @ankushbbbr
    Author

    @justinclift Sorry, I marked the wrong version in the post. I'm using the latest version, 3.9.1, just corrected the same in the post.

  4. MKleusberg commented on May 4, 2017

    @MKleusberg
    Member

    This is somewhat related to #1005 and might be solved with just the same fix.

  5. justinclift commented on May 4, 2017

    @justinclift
    Member

    @ankushbbbr No worries at all. 😄

  6. mglatz commented on Oct 6, 2017

    @mglatz

    please please execute query in separate thread with the option to stop the execution without having to kill the app (and loosing the entire script)

  7. MKleusberg commented on Oct 18, 2018

    @MKleusberg
    Member

    @ankushbbbr (and @mglatz again 😄) Sorry for the long delay here. Are you still interested in this issue? I'm asking because we are currently preparing some changes which add, besides making some other changes, a cancel button to the Execute SQL area. Because it's changing a lot of our code we want to test this as good as we can. Are you interested in giving it a try? You can find the Windows and OSX build here:

  8. self-assigned this
    on Oct 18, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions