Article Preview
Buy Now
| Print: | |
| PDF: |
Databases for REAL
Analyzing the Performance of the REALbasic Database Engine
Issue: 3.2 (November/December 2004)
Author: Paul Lefebvre
Author Bio: Paul Lefebvre is President and Chief Architect of LogicalVue Software, producers of SQLVue, RBUnit, and other products.
Article Description: No description available.
Article Length (in bytes): 4,132
Starting Page Number: 32
RBD Number: 3214
Resource File(s):
3214.sit Updated: Friday, November 19, 2004 at 9:20 AM
Related Link(s): None
Known Limitations: None
Excerpt of article text...
I've written about the new database engine included with REALbasic 5.5, but now we will take a little time to analyze its performance. If its performance meets the needs of the application you will be creating, then you may not need to resort to third-party databases such as SQLite or Valentina.
For this analysis, we will look at creating tables, inserting data, deleting data, selecting data, and creating indexes. First, you should go to the RB Developer website and download the accompanying project. It contains the framework for a database test application which I will be using to measure performance.
Once you have downloaded the test application, you can just run it and click the "Start Tests" button. The tests will run for a minute or so and create a database that is about 10MB in size.
Assumptions
The timings I refer to were generated on a Compaq laptop with a Pentium 4 mobile 2Ghz processor using REALbasic 5.5.2. When run on a PowerMac G4 Dual 1Ghz, the tests took slightly longer. Also the database is created as a virtual volume. We'll see later on what the effect is of using a folder instead.
...End of Excerpt. Please purchase the magazine to read the full article.
Article copyrighted by REALbasic Developer magazine. All rights reserved.
|
