BREAKTHROUGH SPEED ON JOINS; NEW SQL COMMANDS
Leading multi-platform database vendor Paradigma Software, Inc, makers of the ultra-fast Valentina 2 Office Server, announce the shipping of Valentina 2.3.
Valentina 2’s next generation, object-relational database model builds on the traditional relational database model much like C++ builds on top of the C language. All that you know from working with traditional database systems from IBM, Oracle and Microsoft also apply to Valentina-based development. This robust technology excels at ultra fast management of millions of records. Valentina is not another in-memory database but a true disk based DBMS.
Valentina 2.3 includes a dramatic leap forward in speed for database JOINS (including data from two or more database tables) with a new breakthrough algorithm. In a comparative analysis in base configurations between Valentina and MS SQL Server 2000 on Windows, on joins of 5,000,000 and 20,000,000 record test databases, Valentina was between 2-6 times faster than MS SQL Server. Based on file structural differences of even larger databases, Valentina 2.3 can be 50-100 times faster or more (MS Server, mySQL, PostGre, SQLite and Oracle have the same file based limitations), depending on the record size of a table. (more…)