General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I understand that having CDX-tags improves performance of SQL statments in a VFP App. My question is does it also improve performance in the following case: A IIS web site having asp pages with SQL statments pointed at DBF/FPT files sitting in a system DSN 'Free Table Directory' with 'Fetch in Background' off. If the answer is yes, should the tags be on the fields that are used in JOINS, WHERE clauses, ORDER BY, or what???
>
>TIA for any responses to the specific question or to the set up in general.
>
>Paul Emery
Paul;
I do not see any benifit to have a CDX if as an example you are going to use ADO to connect to the data. I could be wrong so let's see what others have to say.
Tom
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