General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Fabio,
if the table is as large as this,
indexes will read only once (since this a static table)
and eliminate the need to read every record,
but only the records which fulfil the searchcriteria.
Since this is a static table, consecutive locates
should be even faster than consecutive seek()'s,
since the .cdx wil be cached on the workstation.
Fist step: create inidices, secondly get the best way to handle
deleted items (delete them in the static table and search with
set deleted off.
my =.02 EUR
thomas
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only