I was answering while uploading family videos to YouTube! :) -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Charlie Noah Sent: Sunday, December 26, 2010 7:02 PM To: U2 Users List Subject: Re: [U2] Migration
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 how often you need a particular select, but this is an approach I have used with success. I like to use an index to cull the file down as much as possible, then use that select to drive the next index select, etc. (if the platform allows it and it's appropriate). Then, when the final list is culled down to the records I need, I use another index select to put the list in the sequence I want. The key can be constructed of multiple fields to get just the desired sequence. No brute force required. One advantage of multi-field keys is small nodes, which means more efficient index updating and selects. Now, you can't go crazy and index everything in sight, but you can design indexes to give you the maximum bang for your buck. At least, this approach has worked well for me. Like it, hate it, throw rocks at it, it's all OK by me. BTW, it's Sunday after Christmas - what are we doing thinking about work today? Merry Christmas and Happy New Year to all, Charlie Noah Charles W. Noah Associates [email protected] The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 12-26-2010 6:50 PM, Robert Houben wrote: > 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 just > do...) So, I find that I often have to assume a lowest common denominator > when building a reusable solution. I may not always be aware of the current > state of a particular platform. I'd love to be corrected if my understanding > of limitations is out-of-date! Last I knew, if you wanted to sort an MV file > by more than one field, regardless of how many indexes you had, you got to > pick one of them, and you would settle for brute force for the others. This > was true, last I knew, of EVERY MV platform I knew of that had indexes. > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Robert > Houben > Sent: Sunday, December 26, 2010 4:42 PM > To: U2 Users List > Subject: Re: [U2] Migration > > 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 > _______________________________________________ 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
