Information générale
Catégorie:
Codage, syntaxe et commandes
Steve,
I would not assume that a SQL Select is slow - you may be surprised if you try it. Of course the speed depends on the query and what appropriate indexes the database engine has to optimise the query with. I for one am a convert to the SQL way of doing things - and I suspect we will see more of it in our futures. <g>
>Jim,
>
>Thanks for the advice.
>
>I assume the LOCATE command also would be preferable to the SQL SELECT command relative to performance and my primary objective of taking inputs from a form to search for matching records.
>
>It will be much easier to use the LOCATE command. I was hoping I could use it, but was concerned that it was a lot slower than SEEK. So that's good news. It makes my life much easier.
>
>Thanks again.
Précédent
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