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 4.6

COLUMN

Databases for Real

REALSQLDatabase (SQLite)

Issue: 4.6 (July/August 2006)
Author Bio: Paul Lefebvre is President and Chief Software Architect of LogicalVue Software.
Article Description: No description available.
Article Length (in bytes): 3,201
Starting Page Number: 36
Article Number: 4613
Related Link(s): None

Excerpt of article text...

Last time we looked at the many commands for manipulating data. Once you have a lot of data loaded, you should consider adding some indexing in order to speed up access to the data. The indexing commands are listed in Table 1.

Adding an Index

An index is essentially a quick way to look up data in a table. Indexing is added to specific columns in a table. The command to add an index is simple:

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