[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: A hundred million rows?

Status
Not open for further replies.
P

Patrice Perrot

Guest
Hi , Extract of my tests , on orderline with 10 000 000 rows , idxactivate index OL_new using itemnum (or orderline). Table activity durng idxactivate : - READ : - _File ->10 000 410 - OrderLine ->10 000 000 - _Field -> 111 - _Index -> 42 - _Index-Field -> 6 - Update - _Index -> 1 INDEX ACTIVITY during IDXACTIVATE - Create - OrderLine.OL_new ->10 010 615 - Read - OrderLine.itemnum ->10 000 001 (same value for OrderLine.orderline ) - _File._File-Name -> 407 - _Index-Field._Index/Number -> 10 - _Index._File/Index -> 5 - Split - OrderLine.OL_new -> 10 637 I think you can add => For each record of the table (orderline) , you do 1 read of _file I find a huge difference between IDXACTIVATE using an "uniq index" and using a "non-uniq Index" , on the "Record LOCK" of promon : - the difference is 20 000 000 - Probably explainable by the fact that the update are alowed when we use an "Uniq index" => cannot create the new index key when its record is locked by another user One more point , After IDXACTIVATE , you probably need to do an IDXCOMPACT on the new index. Patrice

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