E
e.schutten
Guest
With variable iNumSeq in the code, you can change the number of itterations. Per iteration you can set the iMaxCount (number of records to read). What I did was reading 15 x 100.000 records. I did the test on my computer and on the server. I did not use shared memory or single user (production environment). -B 5220000 (8 KB blocksize) Total memory is 256 GB Available 116 GB (small database). With Protop I did not see any OS-reads. We also using -lrkuskip 100. We have a lot of other servers with bigger databases and different configurations. I can do this test also in those environments. BTW with physical I mean Static query. And with 'no cache' I mean that I did not use the CACHE in the define query statement. I could also try CACHE 0.
Continue reading...
Continue reading...