tag:blogger.com,1999:blog-1530930336724030902.post1712048315205846776..comments2023-08-04T17:52:40.205+05:30Comments on Code with PR: READ vs SQL SELECT, A Quick Performance TestPradeep Pangahttp://www.blogger.com/profile/02512006321052858196noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-1530930336724030902.post-68069850371030214812020-10-06T15:21:40.720+05:302020-10-06T15:21:40.720+05:30Hi, I have run the test with 3 million records as ...Hi, <br><br>I have run the test with 3 million records as suggested and the time difference is now about 17 seconds. Below is for your reference. <br><br>CALL PPREAD <br>DSPLY Start: 10.44.43 End: 10.45.13 Records: 3000000 //30 Seconds<br><br>CALL PPSQL <br>DSPLY Start: 10.46.22 End: 10.46.35 Records: 3000000 //13 Seconds<br><br>CALL PPSQL1 <br>DSPLY Start: 10.47.18 End: 10.47.22 Records: 3000000 //4 Seconds<br><br>Thanks,<br>Pradeep.Pradeep Pangahttps://www.blogger.com/profile/02512006321052858196noreply@blogger.comtag:blogger.com,1999:blog-1530930336724030902.post-70481748663900401052020-10-05T22:37:18.820+05:302020-10-05T22:37:18.820+05:30La prueba no es convincente, esos 3 segundos puede...La prueba no es convincente, esos 3 segundos pueden indicar otra cosa, ahora tripliquen los datos a 3millones y revisen si el tiempo se triplicó, así si. Desee el Cibaohttps://www.blogger.com/profile/07063719648540173522noreply@blogger.comtag:blogger.com,1999:blog-1530930336724030902.post-62076688933490400332020-09-28T22:28:54.120+05:302020-09-28T22:28:54.120+05:30Hi,Table was created with Unique Key Constraint an...Hi,<br><br>Table was created with Unique Key Constraint and No separate Index has been created. <br><br>Thanks,<br>Pradeep.Pradeep Pangahttps://www.blogger.com/profile/02512006321052858196noreply@blogger.comtag:blogger.com,1999:blog-1530930336724030902.post-86231255135082911382020-09-28T20:53:03.409+05:302020-09-28T20:53:03.409+05:30isn't the index stored separately from the tab...isn't the index stored separately from the table? If so, the table's size would need to include the index's size to be an equal comparison of storage.dublin.kkhttps://www.blogger.com/profile/07709499391530854521noreply@blogger.comtag:blogger.com,1999:blog-1530930336724030902.post-22374058325097997512020-09-28T16:15:33.013+05:302020-09-28T16:15:33.013+05:30Yes Manu, Test was done on V7R2. However, I am not...Yes Manu, Test was done on V7R2. <br><br>However, I am not anticipating many changes for any of the latest versions (V7R3 or V7R4).<br><br>Thanks,<br>Pradeep.Pradeep Pangahttps://www.blogger.com/profile/02512006321052858196noreply@blogger.comtag:blogger.com,1999:blog-1530930336724030902.post-24373873817108581882020-09-27T16:57:29.152+05:302020-09-27T16:57:29.152+05:30Which version v7r2? Which version v7r2? Manuhttps://www.blogger.com/profile/15542390282974423532noreply@blogger.comtag:blogger.com,1999:blog-1530930336724030902.post-63630142371832465082020-09-24T14:23:05.938+05:302020-09-24T14:23:05.938+05:30Hi Nathan, Thanks for Pointing. I have added ORDER...Hi Nathan, <br><br>Thanks for Pointing. I have added ORDER BY clause to SQL SELECT and ran the test once again. Results are exactly same as it was with out ORDER BY. <br><br>Updated the Results above. <br><br>Thanks,<br>Pradeep.Pradeep Pangahttps://www.blogger.com/profile/02512006321052858196noreply@blogger.comtag:blogger.com,1999:blog-1530930336724030902.post-82817417214007480832020-09-23T22:55:59.010+05:302020-09-23T22:55:59.010+05:30This is not a valid performance comparison. The RP...This is not a valid performance comparison. The RPG READ example reads the table by key, whereas the SQL SELECT example doesn't.<br><br>You might try adding an ORDER BY clause to the SQL SELECT, or change the RPG READ to use BLOCK mode. Then show us the results.<br><br>Nathan Andelinhttps://www.blogger.com/profile/06465418296796909580noreply@blogger.com