How to make filter FASTER?? see message

[petrovlis]

if{Mail_OfferOut_All.Conti} = "N" or {Mail_OfferOut_All.Conti}= "Z" then

if {Mail_OfferOut_All.Origin} = "EEC" then
Int ({Mail_OfferOut_All.FOBEUR}
+ ({Mail_OfferOut_All.RdamAntFreight}/
({Mail_OfferOut_All.Contweight}/1000))
+ {Mail_OfferOut_All.ExtraProfit})/
((100-{Mail_OfferOut_All.CommPct})/100)
else
Int ({Mail_OfferOut_All.CHIEUR} + ({Mail_OfferOut_All.ChinaFreight}/
({Mail_OfferOut_All.Contweight}/1000))
+ {Mail_OfferOut_All.ExtraProfit})/
((100-{Mail_OfferOut_All.CommPct})/100)


else

if {Mail_OfferOut_All.Origin} = "EEC" then
Int ({Mail_OfferOut_All.FOBUSD}
+(({Mail_OfferOut_All.RdamAntFreight}*{Mail_OfferOut_All.USD})/
({Mail_OfferOut_All.Contweight}/1000))
+ {Mail_OfferOut_All.ExtraProfit})/
((100-{Mail_OfferOut_All.CommPct})/100)
else
Int ({Mail_OfferOut_All.CHIUSD}
+(({Mail_OfferOut_All.ChinaFreight}*{Mail_OfferOut_All.USD})/
({Mail_OfferOut_All.Contweight}/1000))
+ {Mail_OfferOut_All.ExtraProfit})/
((100-{Mail_OfferOut_All.CommPct})/100)

THANKS FOR ANY HELP ! - William

 

[BNPMike]

What's the question?

 

[jozerc]

create indexes for all fields used in your filter expr.
follow the rushmore optimization guidelines