Information générale
Catégorie:
Applications Internet
Hi John,
Yes. Indexing your tables will probably give you better speed. THis will be more noticable as the size of your tables grow.
I don't think you'll have much luck attempting to call stored procedures through ADO/ODBC.
Guy
>I'm using ASP and calling ADO to access and update some VFP tables on a relatively small (but important) web application. data retrieval speed is pretty good, but I have a couple questions.
>
>Since I'm using ODBC with ADO to access my tables, do I need to index my tables? Will indexing speed up queries?
>
>How does Referential integrity and stored procedures work (or not) in this scenario?
>
>WWWC is in my future, but for now I must proceed with this approach.
>
>Thanks for any information.
>
>John.
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