Information générale
Catégorie:
Codage, syntaxe et commandes
Hello,
I'm using a form to browse and update a table with the
fields: organisation, customer, ...
On the form only records of one organisation should be
displayed. The user is able to select the organisation
with a command button. I have set a filter like this:
organisation = '001'
I have also an index on organisation to optimize the filter.
But it is still very slow:
e.g. Organisation '001' 150000 records
Organisation '002' 250 records
It seems that in the case of organisation '002' all records
were read -> takes 70 seconds to move from the first to the
last record.
Without a filter it is quite fast.
Any suggestions?
Thanks in advance.
Andreas
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