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 was answering while uploading family videos to YouTube! :)
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Sunday, December 26, 2010 7:02 PM
To: U2 Users List
Subject: Re: [U2] Migration
I've b
I've been lurking, following this thread, and I guess I have to stick my
2 cents in. I've worked with MV for 33 years, from Reality to jBASE, and
one of the best features ever added was secondary indexes. Choices
depend on the platform, the iron involved, size and structure of the
database and
I should also clarify that we have a lot of customers we support on mvBase,
mvEnterprise, D3 and lots of other platforms, and yes, we do have PI Open
customers... I recognize that the topic here is U2, but even there, we have
customers who use our products running on Universe 5 (don't ask, we j
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-user
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