Hi Ben, In T24 for example someone can easily deduce that majority of TABLES are random. The reasons are not too far to fetch, e.g CUSTOMER, ACCOUNT are random. While are the majority of the TABLES random, this is because majority of the tables has it primary key and at the same time embedded with foreign keys to other tables. Like in ACCOUNT, you will agree with me that apart from it primary key which is ACCOUNT.NUMBER, it also has a lot of foreign keys to other tables. Then when you at the way some of the tables were created you will notice that through their path almost all has a DICTIONARY i.e ]D; this also show it is random table. Now coming down to jbase, you must note that all randomly created tables are also Sequential in nature because all the records in those randomly table are arranged sequentially through their primary key.
The above is in addition to what Jim has contributed. Thanks and Regards 2009/6/6 Ben <[email protected]> > > Hi, > > How can I know the T24 is sequential , random or mix? > I guess T24 is mix. It has sequential and random both. > > If I execute the select in Jbase, it is sequential or random IO? > In jbase or T24, there are many api such as SELECT, READ, WRITE, > READNEXT etc. How can I know they are sequential or random? > > Best regards, > Ben > > > > -- Raphael --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
