Hi Robert Performance Benchmarking needs to be aligned with a business measure.
Most performance benchmarks are done on the basis of Simple transactions per second. However where U2 realy bolts ahead is in complex transactions per second. In the realworld we have complex transactions, not always the simple Dr,Cr of a general ledger. A transaction will often involve various business rules and accessing multiple files for checks and process tables. With most RDBMS as the complexity increases, the more likely they will have to resort to processing outside of the database which causes a performance hit. With U2, the processing remains inside the database where basic code resides. Hence before doing performance benchmarking, make sure that the benchmarking represents the business process. It is like using a ferrari to delive furniture, it may be fast but it is the wrong vehicle for the job. Regards David Jordan > Is anyone aware of any performance benchmarks for UniData 7.1? How does > it stack up against SQL 2005? > > > Robert K. Kubarych > Network Services > Bergen Community College > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
