Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Daniel,
>I assume that each of the fields being joined and/or filtered on are indexed (including deleted). If not, that may also help.
Indexing on DELETED() is seldom a good idea. Actually this might be Nadyas problem. Indexes on deleted() on large tables create a massive overhead which might be very well the cause of her problems. It's generally proven that DELETED() tags almost never helpfull in gaining performance, but could make you app terrible slow.
Walter,
Previous
Next
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