Valentina 2.3 for Revolution Released
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.
Valentina 2.3 also includes the following new features and improvements:
* Improved speed and performance in Add Record commands.
* New SHOW commands: SHOW TABLES, SHOW COLUMNS, and SHOW DATABASE. These return the database structure as a cursor.
* SQL: SELECT ... ORDER BY ... [NULLS FIRST | LAST]
* SQL: CREATE TABLE ... IF EXISTS
Valentina 2.3 improvements are available in all versions of Valentina Office Server and ADKs for COM (VB 6, Delphi), .net (VB 2005), Macromedia Director, Runtime Revolution and REALbasic, as well as Embedded Server (a part of Valentina Developer Network).
Valentina 2.3 for Revolution is available through Runtime Revolution's RevSelect program.
Valentina Studio, the browser, query, and administration tool was updated to version 2.3fc16, including support for the new Valentina 2.3 file format. The Mac OS X version is a Universal Binary application.
ADK Standard Edition ADKs start at $199; VDN pricing begins at $499. Owners of the 2.x versions of the products receive a free upgrade to 2.3.
For more information, visit the Paradigma Software website at http://www.paradigmasoft.com.
Valentina 2.3 for Revolution Released
Creating desktop or client-server database solutions?
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Jump to
- LiveCode Community
- ↳ Announcements
- ↳ Developer Services Marketplace
- ↳ User Groups and Events
- ↳ SoCal LiveCode Group
- ↳ Greater Toronto Area LiveCode Users Group
- ↳ Off-Topic
- ↳ Made With LiveCode
- Getting Started With LiveCode
- ↳ Getting Started with LiveCode - Complete Beginners
- ↳ Getting Started with LiveCode - Experienced Developers
- ↳ Converting to LiveCode
- ↳ App Building Course
- ↳ Simple Messages
- ↳ Calculator
- ↳ Notes
- ↳ Clock
- ↳ Web Browser
- ↳ Weather
- ↳ Compass
- ↳ Photos
- Developing With LiveCode
- ↳ Talking LiveCode
- ↳ Databases
- ↳ Games
- ↳ Internet
- ↳ Multimedia
- ↳ Software Engineering
- ↳ Version Control
- ↳ Feature Proposals
- ↳ Bug Triage
- ↳ Legacy Project: MetaCard
- Extending LiveCode
- ↳ Using Plugins for Customizing the LiveCode IDE
- ↳ Using Externals
- ↳ Making IDE Plugins
- ↳ Building Externals
- ↳ LiveCode Builder
- Platform Specific
- ↳ Windows
- ↳ Mac OS
- ↳ Linux
- ↳ iOS Deployment
- ↳ Android Deployment
- ↳ CGIs and the Server
- ↳ HTML5
- ↳ Raspberry Pi
- Academic Endeavors
- ↳ Teaching with LiveCode
- ↳ Research and Post Secondary
- ↳ LiveCode University
- ↳ Educational Outreach
- Livecode Open Source Archived Forum- closed to posting
- ↳ Engine Contributors
- ↳ IDE Contributors
- ↳ Documentation and Tutorials
- ↳ Brainstorms
- ↳ Community Projects
- ↳ rIDE
- Third Party Extension Support
- ↳ Marketing Your Products
- ↳ Animation Engine
- ↳ chartsEngine
- ↳ MobGUI
- ↳ lcTaskList
- ↳ SQL Yoga
- ↳ MergEXT
- ↳ Data Grid Helper
- ↳ idea2app and Coding School
- ↳ Admin Archive
- LiveCode Hosting
- Forum Archives
- ↳ Archived: Third Party Extension Support
- ↳ rTree
- ↳ rGrid
- ↳ Data Tree
- ↳ Archived: LiveCode Open Source
- ↳ LiveCode Global Jam
- ↳ Testing Support
- ↳ Archived: Academic Endeavors
- ↳ September Academy
- ↳ Summer School 2013
- ↳ Archived: Project Specific
- ↳ Business and Kiosks
- ↳ Digital Art and Portfolios