filtering performance

Posts   
 
    
Fatih
User
Posts: 8
Joined: 06-Jul-2007
# Posted on: 06-Jul-2007 10:06:01   

i ve filter like this int seasonMonth = int.Parse(ddlMonth.Text); int seasonYear = int.Parse(ddlYear.Text);

    IPredicateExpression filterMonth = new PredicateExpression();
    IPredicateExpression filterYear = new PredicateExpression();

    filterMonth.Add(GainBudgetByRepFields.SeasonMonth == seasonMonth);
    filterYear.Add(GainBudgetByRepFields.SeasonYear == seasonYear);
    filterMonth.AddWithAnd(filterYear);


    IPredicateExpression filterDetailsMonth = new PredicateExpression();
    IPredicateExpression filterDetailsYear = new PredicateExpression();
    filterDetailsMonth.Add(GainBudgetByRepDetailedFields.SeasonMonth == seasonMonth);

    filterDetailsYear.Add(GainBudgetByRepDetailedFields.SeasonYear == seasonYear);
    filterMonth.AddWithAnd(filterDetailsYear);

    ldsByRepID.FilterToUse = filterMonth;
    ldsByDetails.FilterToUse = filterDetailsMonth;

this works well but when i change to operator to >= i faces with connection time out

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 06-Jul-2007 10:37:55   

but when i change to operator to >= i faces with connection time out

Is this change applied to all the predicates or just one?

Would you please examine the generated queries in both cases (before and after the change), and manually run them directly against the database to see if the same problem occurs on the database side.

To get the generated query, please consult the manual's section "Using the generated code -> Troubleshooting and debugging"

Also please post the generated queries here. If you could not sort out the problem.

Fatih
User
Posts: 8
Joined: 06-Jul-2007
# Posted on: 06-Jul-2007 11:11:54   

yes i applied to all predicates, .actually i don't know what problem is i ll try explain that

when i change to == operator to >= after i waited too much results seems on my page than i change to filterelement value and post it again page redirect an error page when seems no connection

Fatih
User
Posts: 8
Joined: 06-Jul-2007
# Posted on: 06-Jul-2007 11:26:12   

i found solution i must cast value as true to llbgendatasource.allowpaging property