I have one file that has 30 indexed fields, UV 10.3.something. I have
noticed that, since switching from Linux to Windows, I can't rely upon
the index being sorted though.
Jerry
On 12/26/2010 6:42 PM, Robert Houben wrote:
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
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
