I am not familiar with UniData and I am aware that UniVerse has had better SQL support than uniData. I have found that UniVerse SQL performs well. The UniVerse query engine is used by both SQL and retrieve, where they pass the query over to an optimizer engine. One thing that has been a bit slow is the ODBC driver which has been updated at release 11.1 . Also the query integrates with EDA, so I can be selecting data off a UniVerse, Oracle and SQL Server at the same time. I would be interested in comparisons in performance of a similar data file with similar indexs, triggers, etc. There is also a consideration issue whether systems are designed for fast retrieval or fast update. It is difficult to assess query performance, we all know how meaningless the old TPS tests were that the RDBMs used to quote all the time.
I agree with Dawn some of Caches object model for data is quite innovative and how it propagates to client tools is nifty. With IBM U2 was under resourced, with Rocket U2 has better resources and it is in a much better position to advance quickly with new innovation, it is now time for ideas. David Jordan _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
