Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
If there are any indeces on deleted() or other expressions which result in a pure logical result [empty() mostly, which is sometimes necessary if !=="" does not fit the UC] , define those indeces as binary. Drastic speedup due to size reduction if they are used - much better than trying to figure out if those indeces on deleted() help or hinder if seen from an "app in total" POV.
regards
thomas
>A client of mine has issues with slow response times. So, I was trying to understand this a bit more clearly than I had previously understood it. I've been able to help some clients with improving response times by rebuilding their index files from scratch, doing a delete tag all, etc., but, of course, I recorded the index expressions and tag names beforehand. I've also archived clients' data to archival tables so that the table files are reduced in file size, which seemes to help also.
>
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