G
George Potemkin
Guest
> George, as a suggestion for the future... you may want to include the elapsed ETIME output in your tests I did it. Also I added more statistics and now program saves the results to an output file. New version of program is the updated message above. I run the additional tests against sports2000 -Mm 32000 with Progress V11.7.2 on Windows: FOR EACH Customer NO-LOCK WHERE Country EQ "Finland" vs the same query and -prefetchNumRecs 1000 vs FOR EACH Customer NO-LOCK WHERE Country EQ "Finland" USE-INDEX NAME vs the same same query and -prefetchNumRecs 1000 Results: Messages receiv: 4 2 13 2 Messages sent: 3 1 12 1 Bytes received: 608 392 1580 392 Bytes sent:5008 4816 5884 4816 Records received: 0 0 0 0 Records sent: 28 28 28 28 Queries received: 3 1 12 1 Time slices:26 28 187 198 Record Reads: 28 28 1117 1117 Index Reads: 29 29 1118 1118 DB Access: 59 59 2260 2260 DB Read: 2 2 48 48 Record Count: 28 28 28 28 Execution Time: 0 0 2 2 It's the -prefetchNumRecs 1000 that makes the difference.
Continue reading...
Continue reading...