Information générale
Catégorie:
Gestionnaire d'écran & Écrans
Seek cannot be beat for data retrieval based upon a single index expression. If you need to retrieve data based upon multiple optimized expressions the use either locate or SQL-Select.
ie. Locate for state='MI' and city='TRAVERSE' or
Selecte * from MyTable where state='MI' and city='TRAVERSE'
Glenn
>Moises,
>
>As Alex has said Locate can be as effective as Seek, however, you need to be very careful and ensure that your statement is Rushmore optimised or you will have a performance hit.
>
>Locate is powerful in that it will sequentially read through a table if it can't use Rushmore, however the downside is that it can be very slow.
>
>Regards,
>
>Aaron
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement