Looking for Best Way to Optimize Clarion Code for Performance?

[vitesse]

Hi Daniel Jose

are you related to Priyal? She had a very similar question a while ago.

see my answer at

How to Optimize Clarion Code for Better Performance

Hi Priyal as others have suggested, more information would be helpful. obviously things like database query efficiency is largely outside the realm of Clarion, but could make an enormous difference. Having said that, you need to be sure any filter is being executed on the backend and all the data is not being passed over the network to your program to be filtered locally. Others will know a lot more about that than me, but you can do various traces and check what query is being passed to the…

cheers

Geoff R