On 24/12/10 15:50, Robert Houben wrote: > SQL will beat MV every time when you sort fields that are indexed.
Huh? Ime (UniVerse), that's wrong. Indexes are b-trees, which you can walk, and the contents of the index are sorted. afaik you would have been right about PI, but that's long dead. Dunno about UniData, but UV is a lot of sites where MV will equal SQL ... :-) > For direct reads, MV seems to have a slight advantage. Inserts and updates > that affect indexed fields are slower in SQL (inserts are painfully slow if > you fail to size your SQL table well, but try "inserting" millions of records > into a file with a modulo of 1...) Been there, done that. But that's why most places use dynamic files nowadays. :-) Cheers, Wol _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
