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 2.6

COLUMN

Performance Tips

Issue: 2.6 (July/August 2004)
Author: Paul Lefebvre
Author Bio: Paul Lefebvre is President and Chief Architect of LogicalVue Software, producers of SQLVue, RBUnit and many other products.
Article Description: No description available.
Article Length (in bytes): 5,295
Starting Page Number: 32
Article Number: 2615
Related Link(s): None

Excerpt of article text...

Generally speaking, it is pretty easy to make a database. But after you have used it a while and have accumulated lots of data, it may start to slow down. There are several simple things you can do to help with performance. These tips are relatively generic and can be applied to any database engine.

SQL

Don't Use SELECT *

This is a common mistake. Instead of SELECT *, which sends all columns from the database to your application, list only the columns you need in the order you want. This decreases the amount of work the database has to do and also decreases the amount of network traffic (if you are using a database server).

Minimize Joins

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