Wally, That's what I'm talking about!! Thanks for the update...
Here's another one: temp files are very important in SQL. Another example of an improvement would be to get the SQL temp files to work outside of the old AE style SQL editor, in BASIC especially. Then, we could use one of most powerful features of UniSQL, which is dynamically created temp files. Then, we could do things like selects files, group them and summarize data and then select on the summary data. That would save hours of coding this kind of stuff!!! Example: SELECT CUSTOMER,ORDER,SUM(QTY),SUM(AMOUNT) FROM ORDERS TO CUST_SUM_TEMP; SELECT CUSTOMER,ORDER, QTY,AMOUNT FROM CUST_SUM_TEMP ORDER BY AMOUNT; Brad ----- Original Message ----- From: "Wally Terhune" <[email protected]> To: "U2 Users List" <[email protected]> Sent: Monday, October 12, 2009 10:19:29 AM GMT -05:00 US/Canada Eastern Subject: [U2] UniData - BUILD.INDEX on large file - comment You shouldn't have any problem with TMP files exceeding 2gb with BUILD.INDEX at UniData 7.2 - assuming your TMP filesystem supports large files. I presume this was the problem Brad encountered. Prior to 7.2, you may have an issue if you PHANTOM the BUILD.INDEX command, or if you start a udt session, shell out of it (!sh), cd to another directory, start a new udt session and BUILD.INDEX there. Regards Ps - posted from Liverpool! Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: [email protected] Web: www.rocketsoftware.com/u2 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of BraDav Sent: Sunday, October 11, 2009 10:27 AM To: U2 Users List Subject: Re: [U2] U2 is now Rocket U2 Charlie, I agree with you overall that U2 (Unidata and Universe) is the best there is for development and maintaining applications. The data model stands head and shoulders above the rest, when it comes to RAD. However, there could be many improvements to the dbs, above and "below the hood" so to speak. That being said, one of the benefits of the U2 architecture is that it "can" be improved. For example, I maintained a file with 80 million records, at one site. It has virtually no overflow and the record distribution was nearly perfect. Access to the file was very fast, but we couldn't create indexes on it, because the indexes ran out of space. That's just one example, but the list is long. However, that's a positive. With the right amount of R&D, U2 is positioned for another 20 year run. thanks, Brad _______________________________________________ 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
