Should have clarified "when you sort *multiple* fields that are indexed". I still haven't heard anyone tell me that either UV or UD now support more than one indexed field. Let me know if this has changed...
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Wols Lists Sent: Sunday, December 26, 2010 4:33 PM To: [email protected] Subject: Re: [U2] Migration 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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
