I agree. Trying to compare a relational database (such as SQL Server) and a post-relational database (such as UniData) is like trying to compare apples and oranges. Your best bet is to analyze how you are going to use the data, and pick the database that can handle those needs.
Thanks, Nick Cipollina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Thursday, July 12, 2007 10:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance 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 > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/