Query very slow with large tables MSSQL

Completed

Comments

6 comments

  • Please indicate your Active Query Builder version and edition, syntax provider being used.

    0
    Comment actions Permalink
  • Avatar
    Ronélio Oliveira

    According to "acQueryBuilder.ver" file, my version is 1.23.9.0 Standard Edition.

    Syntax provider is acMSSQLSynProvider

    0
    Comment actions Permalink
  • Avatar
    ActiveDBSoft support team

    Hi Ronélio,

    the version you using is 2 years old, in these 2 years we implemented many improvements in the MS SQL parser.

    I tried your query on the latest version - and QueryBuilder loads this query almost instantly. Could you please test the latest version?

    ×

    0
    Comment actions Permalink
  • Avatar
    Ronélio Oliveira

    Ok!

    We're trying the new version to check if this issue were fixed.

    0
    Comment actions Permalink
  • Avatar
    Ronélio Oliveira

    Hi,

    We tried with new version of QueryBuilder and We got the same problem.

    When I'm debugging and freezes at this point SelectStatement := TacQueryBuilderAccess(QueryBuilder).ParseSQL(SQL, false, false));

    0
    Comment actions Permalink
  • Avatar
    Sergey Kraikov

    Hello Ronélio,

    unfortunately, I still cannot reproduce this issue using the latest version, seems the
    latest version works fine.

    Could you please test your query using our precompiled demo application from
    http://activequerybuilder.com/files/aqb_demo.zip ?

    0
    Comment actions Permalink

Please sign in to leave a comment.