Desktop app deployment on lan

[abdulmojeb]

Copy that. Thanks a lot.

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

[barrymavin]

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.

[abdulmojeb]

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?

[barrymavin]

No LOCATE will do a sequential scan.

You should use

SEEK key
SCAN REST WHILE ...

[abdulmojeb]

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.

[barrymavin]

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.