[progress Communities] [progress Openedge Abl] Forum Post: Re: Strange Performance Issue :...

  • Thread starter Thread starter cverbiest
  • Start date Start date
Status
Not open for further replies.
C

cverbiest

Guest
Hi George, thanks for your reply, results of your code in the second table. I found out that my idea that there is a difference between artikel1 and artikel2 index is wrong. If I read all records instead of just the first 100, the times are similar for either index. There is a big difference between e.g. value 1 and value 5, both queries take about 6 seconds but the query for value 1 returns 10x more records value index loop time #records size size/time ----------- ----------- ----------- ------------ ----------- ------------ ---------- 1 1 1 6.267 18.012 11.166.397 1.781,78 1 1 2 6.058 18.012 11.166.397 1.843,25 1 2 1 6.014 18.012 11.166.397 1.856,73 1 2 2 6.296 18.012 11.166.397 1.773,57 2 1 1 1 2 1.175 1.175,00 2 1 2 2 2 1.175 587,50 2 2 1 1 2 1.175 1.175,00 2 2 2 2 2 1.175 587,50 3 1 1 6.802 18.713 13.811.638 2.030,53 3 1 2 6.866 18.713 13.811.638 2.011,60 3 2 1 7.004 18.713 13.811.638 1.971,96 3 2 2 6.898 18.713 13.811.638 2.002,27 4 1 1 2.732 7.468 4.170.267 1.526,45 4 1 2 2.310 7.468 4.170.267 1.805,31 4 2 1 2.175 7.468 4.170.267 1.917,36 4 2 2 2.451 7.468 4.170.267 1.701,46 5 1 1 5.951 1.821 1.269.847 213,38 5 1 2 5.917 1.821 1.269.847 214,61 5 2 1 5.928 1.821 1.269.847 214,21 5 2 2 5.995 1.821 1.269.847 211,82 6 1 1 757 2.389 1.619.747 2.139,69 6 1 2 735 2.389 1.619.747 2.203,74 6 2 1 884 2.389 1.619.747 1.832,29 6 2 2 930 2.389 1.619.747 1.741,66 7 1 1 1 0 0 0,00 7 1 2 1 0 0 0,00 7 2 1 1 0 0 0,00 7 2 2 1 0 0 0,00 8 1 1 2 0 0 0,00 8 1 2 1 0 0 0,00 8 2 1 1 0 0 0,00 8 2 2 1 0 0 0,00 9 1 1 480 805 520.384 1.084,13 9 1 2 394 805 520.384 1.320,77 9 2 1 417 805 520.384 1.247,92 9 2 2 386 805 520.384 1.348,15 ────────────────────────────Seek Ratio───────────────────────────── File-Name Index-Name Ratio ───────────────────────── ───────────────────────── ────────────── ARTIKEL ARTIKEL-ID 1.680,92 ARTIKEL ARTIKEL1 152,63 ARTIKEL ARTIKEL10 152,63 ARTIKEL ARTIKEL11 167,31 ARTIKEL ARTIKEL12 1,00 ARTIKEL ARTIKEL13 165,54 ARTIKEL ARTIKEL14 106,77 ARTIKEL ARTIKEL15 1,00 ARTIKEL ARTIKEL16 167,31 ARTIKEL ARTIKEL17 1,00 ARTIKEL ARTIKEL18 1,00 ARTIKEL ARTIKEL2 350,27 ARTIKEL ARTIKEL3 329,21 ARTIKEL ARTIKEL4 158,17 ARTIKEL ARTIKEL5 150,79 ARTIKEL ARTIKEL6 152,63 ARTIKEL ARTIKEL7 152,63 ARTIKEL ARTIKEL9 1,00

Continue reading...
 
Status
Not open for further replies.
Back
Top