Search results

Ok. i changed the code and put yours fragments in it. the report was for all the data (the longest). etime = 323,01 etime - hole program - 551 summaring lr lp --- ------ 0 61838 0.00 not all 10 minutes is not as bad already. If You have any more suggestions please reply.

i don't have this xref.. On my hole comupter there is no file which is called xref.. i cannot use it.. Records.. Hmm.. Around 40 000 baybe more.. in the temp-table. i can put indexes thich are on these tables: Table: pt_mstr Flags Index Name St Area Cnt Field Name -----...

Thx again. I used etime in different areas and it look like the most time (220 out of 311) i spend in this fragment of the code: FOR EACH wo_mstr NO-LOCK WHERE wo_due_date >= data_u AND wo_rel_date >= data_u AND wo_rel_DATE <= data_u1 AND wo_cc >= buyer1...

Thanks! I did what You both said. Here is my new code: It is faster (almost 30%!! - thanks!!) but not fast enough.. I think it is a problem with temp-tables.. i have to use it 3 times and they are slow somehow.. If You have any other ideas please help! What is it xref output? i don't know how...

Hi. I use temp-tables in my code and its so slow that it takes ours to create a raport.. I don't know what i am doing wrong with temp-tables.. Please help me if You can. Here it is: DEFINE VARIABLE data_u LIKE wo_rel_date NO-UNDO INITIAL TODAY. DEFINE VARIABLE data_u1...