Re: [U2] Migration

2010-12-26 Thread Jerry
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

Re: [U2] Migration

2010-12-26 Thread Robert Houben
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

Re: [U2] Migration

2010-12-26 Thread Charlie Noah
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

Re: [U2] Migration

2010-12-26 Thread Robert Houben
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

Re: [U2] Migration

2010-12-26 Thread Robert Houben
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

Re: [U2] Migration

2010-12-26 Thread Wols Lists
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