Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 3.3

COLUMN

Analyzing the Performance of the Database Engines

Issue: 3.3 (January/February 2005)
Author: Paul Lefebvre
Author Bio: Paul Lefebvre is President and Chief Software Architect of LogicalVue Software, producers of SQLVue, RBUnit, and other products.
Article Description: No description available.
Article Length (in bytes): 6,028
Starting Page Number: 32
Article Number: 3314
Related Web Link(s):

http://sqlabs.net/index.shtml

Excerpt of article text...

Last issue, I wrote about some performance results for the REALbasic 5.5 database engine. For further comparison, this time we'll look at the performance of SQLitePluginPro (http://sqlabs.net/index.shtml) and the original REALbasic database engine. As you will see, not all databases are created equal. Hopefully, with the information here you will be able to decide how to best select a database engine for your REALbasic projects.

As I did last time, for the analysis we will look at creating tables, inserting data, deleting data, selecting data, and creating indexes. The times I refer to were generated on a PowerMac G4 Dual 1Ghz using a modified version of the test application from the last analysis. The test application was built using REALbasic 5.5.3. The results of tests against these database engines are summarized in Table 1.

REALbasic Database Engine (5.5 and newer)

These results were all discussed in the last column. They are included in the table for comparison purposes. You can download the test application that generated these results from the REALbasic Developer web site. Included in the table are the results for creating databases as virtual volumes (VV) or as folders. As you can see, the REALbasic 5.5 database engine is much faster when it creates databases as folders.

...End of Excerpt. Please purchase the magazine to read the full article.