Field index required for Dialog Browser


Author
Message
Edhy Rijo
E
StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Thanks for the clarification. 

Back in VFP it was recommended to have an index in every column used in the where condition to make use of the Rushmore technology in VFP, now in MS-SQL, it is more of monitoring the application performance before start adding indexes all over Tongue.

Edhy Rijo

Trent Taylor
Trent Taylor
StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
Do you remember that really long session that Ben gave over SQL Server during the class...that would be the section I would refer you back to in regards to answering this question.

Generally we will never add an indexes haphazardly and only add them when we see a performance issue.  Just adding an index on all of these fields would probably not be a good idea as they may just produce overhead or even slow things down.  Dealing with dates especially if you are going to have some between operations may be a good place for an index...but this really depends on the database size, performance that you are experiencing, etc.  So I can't give you a "Yes" or "No" answer here....it is more of a trial and error when dealing with performance issues.

Edhy Rijo
E
StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
What is the rule for the need of indexes on fields used in a Dialog Browser?

I have a Dialog Browser with 10 fields (see attached picture) and I am wonder if I should have an index on these 10 fields?

Thanks!

Edhy Rijo

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search