Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Desktop app deployment on lan

  1. #11
    Member
    Join Date
    Sep 2015
    Posts
    80
    Copy that. Thanks a lot.

    So I have to rebuild all my index files and try to run the system again.

  2. #12
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,769
    That one index you created with alltrim is not being used to optimize the query properly because the keys are variable length. You don't need to use trim functions in Lianja like that.

    If you look at the output from EXPLAIN you can see that the optimizer is using a partial key match to reduce the amount of sequential reads but it still has to scan down through the the records as the index is not being used properly to optimize the SELECT.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  3. #13
    Member
    Join Date
    Sep 2015
    Posts
    80
    Please look at this code

    select artrans
    locate for atco='PF' and attype='CV' and atno='134066' and atcd='S'
    if found()

    endif

    Does the query is still optimize as the SQL select statement do? How can I use EXPLAIN command in NoSQL command to test it myself?

  4. #14
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,769
    No LOCATE will do a sequential scan.

    You should use

    SEEK key
    SCAN REST WHILE ...
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  5. #15
    Member
    Join Date
    Sep 2015
    Posts
    80
    Really?

    What about the replace and delete command?

    Then that should be the reason why my app responds so slow. I'll have to decode my program and try to run it again. Thank you very much for your support to a beginner like me.
    Last edited by abdulmojeb; 2015-12-09 at 02:05.

  6. #16
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,769
    You have to SEEK and use the REST scope to manually optimize NoSQL-style of commands. SQL command optimization is handled by the SQL optimizer.

    Performing sequential scans in a LAN is bad practice and is not recommended.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

Page 2 of 2 FirstFirst 12

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us