EntityView2<QrySkillSearchOrderEntity> SkillView = new EntityView2<QrySkillSearchOrderEntity>(_oSkills); QrySkillSearchOrderEntity Skill = new QrySkillSearchOrderEntity(); IPredicate filter = (TblSkillFields.SkillId == SkillId); SkillView.Filter = filter; if (SkillView.Count > 0) {
.... } else { .... }
_oSkills has about 60,000 records but his performs very slow. Is their a better way to search the records for a particular record.
Try to unbind the view from any bound controls. Though it shouldn't be that slow.
Also, which llblgen pro version/ runtime build nr?
its not bound any controls.
llblgen 2.6,adapter,winforms,dotnet2
Perhaps you should do a linear search? The predicates do a compare which might be less efficient, though we believe it should be fast enough.
EntityView2<QrySkillSearchOrderEntity> SkillView....... ... IPredicate filter = (TblSkillFields.SkillId == SkillId);
Are you trying to filter on a field of a related entity?
on a field
These are the results for my test on a 60,000 record's table (ms= milliseconds):
Fetch the entities: 1938ms Build the EntityView2: 14ms Filter the EntityView2: 93ms
Could you please post the DDL structure of your table so we could test that?