How to improve the access speed of a database

The speed of different database types is sorted from fast to slow as follows: Paradox→access→dbisam→dbase.

To improve database access speed, especially traversal speed, the following measures can be used.

1, with the field ordinal read and write data and not through the field name, I Paradox database test, the speed difference is one times. The impending Table->fieldbyname ("")->asxxx changed to Table->fields->fields[i]->asxxx, the speed was raised nearly one times. Of course Fieldbyname ("") than Fields[i] compatibility is good, when the results of the table change without changing the program, and the program is easy to read, so the speed does not make the request, it is best to use the Fieldbyname ("").

2. Do not use the Control data Display component ttable to access the database, especially when the calculated field is created in the ttable for display control, it is best to dynamically create a new Ttable object to access the database.

3, read data can be set each time to read a piece of data, such as:table->blockreadsize=table->recordcount+1; this can greatly increase the speed of reading, but this parameter set to other values may appear some problems, I do not know why?