Copy that. Thanks a lot.
So I have to rebuild all my index files and try to run the system again.
Copy that. Thanks a lot.
So I have to rebuild all my index files and try to run the system again.
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
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?
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
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.
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
Bookmarks