S
Stefan Marquardt
Guest
Hmm, when I use TABLE-SCAN protop shows READS twice, without the same read/create amounts. I just hit another problem using this code, the deletion was dramatically slow. outer: do while true transaction: iOuter = 0. for each X00_BOOKING table-scan exclusive-lock: iOuter = iOuter + 1. delete X00_BOOKING. if iOuter = 100 then next outer. end. leave outer. end. After I changed it to for each X00_BOOKING exclusive-lock: delete X00_BOOKING end. .. it was 10 times faster. This table is in an AREA II. Doc: TABLE-SCAN provides the most efficient access method when retrieving all rows of a temp-table or a database table in a Type II Storage area. TABLE-SCAN returns these rows without using an index. When the TABLE-SCAN keyword is used, the AVM only accesses the record block instead of both record and index blocks.
Continue reading...
Continue reading...