News Article

Apollo SQL 6.1 Explained

Just so everyone understands what is so significant about Apollo SQL 6.1, which affects: Apollo SQL 6.1, Apollo Server 6.1, Apollo ASP 6.1.

Since almost all of our Apollo product development is done using Delphi, we took advantage of our own TApolloTable component for writing Apollo SQL with versions 5.x through 6.0. These previous versions of Apollo SQL (both the SQL built-into Apollo Server and our local SQL engine) used TApolloTable internally with SpeedMode set to true, which maximized its performance.

The Apollo SQL 6.1 architecture is completely different.

We rewrote our SQL 6.1 engine to call our Apollo API (SDE) directly. With SQL 6.1, all of the TApolloTable code has been removed, which means Apollo SQL 6.1 leaner and, as you can see, much faster too! Apollo SQL 6.1 benchmarks can been seen here: News_020725_SQL61Speed.asp

The caveat was that some of the nice features that our SQL engine was taking for granted in TApolloTable (actually, TDataSet) , no longer exist, which means we had to code these missing features in SQL 6.1 from scratch.

The good news is that our extensive internal testing and some quality feedback from Apollo users making heavy use of the Apollo Server, has helped us deliver a solid Apollo SQL 6.1.