Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Hi All,
>
>I captured 3 tables from database not in foxpro, i made 2 links between 2 tables and 1 like between main table and another and if you ask me why 2 links i'll tell you it should be like this, the problem now the querey here is very very slow and as I said i captured the tables not from foxpro from another database and i don't need to export these tables because i need them in live. so how can i increase the speed between these 3 tables and two of them linking between each other with 2 links I tried in querey view it was very good and the result was correct but the problem was the speed.
>
>Thanks for your reading.
Hi -
that speed metric sounds very slow - almost as if you are performing a table scan during each iteration inside your WHERE clause .
Lets assume for the moment that the fields/columns used in your query ARE NOT INDEXED at the back end.
So - to decrease the return time, you will need to add indices on those columns at the back end database.
The question now becomes:
1. do you have rights to do this?
2. will you violate any support agreement by adding indices to some other vendors database schema ?
Take apart your WHERE clauses - look at each field/column that you want to use. Check to see in the vendors database if there is actually an index on each column that you are using in your WHERE clauses.
hth - mondo regards [Bill]
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