Code Performance Question

infonote

Hi,

Our system is currently experiencing some performance problem. I am trying to optimise the code as the tables are Huge.

I think the code which could be optimised is like this fields changed:

If Table1.find('-') Then
Repeat
  If(table1.A = table2.A) AND
  (table1.B = table2.B) AND
  (table1.C <>0) THEN
....

I am thinking about optimising the code.

Are there any sites/forum thread/blogs which I can read to try to improve performance of the system?

Using Nav 3.7

Thanks in advance.

einsTeIn.NET

Read chapter performance of the Application Designer's Guide.

garak

also read the post in SQL Performance Subforum ...

Bgestel

maybe there was a good reason for programming it like that. And that could be only be put for sure if you look at the surrounding code and table design.

I would have expected something like:

table1.setrange(A,table2.A);
table1.setrange(B,table2.B);
table1.setfilter(C,'<>%1',0); 
if  Table1.find('-') Then 
  repeat

So i think it is a good idea to read the entire Application Designer's Guide to be found in the doc directory on the product cd

azerty74

A first question that comes to mind is: Are you working in the native database or on Sql Server ? This has some impact on how to optimize your code.