General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
>
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