Newbies dononyx Posted January 6, 2001 Newbies Share Posted January 6, 2001 I am wondering if anyone knows what the fastest way to perform calculations are: See Example 1 vs 2: box1= (DayOfWeek(Date(month,1,year))=1,1,"") box2 is related to box 1 box2= Case(DayOfWeek(Date(month,1,year)=1,2, DayOfWeek(Date(month,1,year)=2,1,""). My question is would it be faster to use this box2= Case(box1,2, DayOfWeek(Date(month.1.year))=2,1,"") I will have a db of over 800 fields most of which are calculations so I need fastest possible!! Link to comment Share on other sites More sharing options...
LiveOak Posted January 6, 2001 Share Posted January 6, 2001 Did you leave out an "If" in the description of box 1? I have heard that Case() statements are faster than If() statements, but before I based a complicated design on this conclusion I'd build a test file and do an experiment. -bd [This message has been edited by LiveOak (edited January 06, 2001).] Link to comment Share on other sites More sharing options...
JW Posted January 9, 2001 Share Posted January 9, 2001 I update (new version) all my files - 52 related files with approx. 3600 fields - 2800 are calc fields - 60000 records in two of them. I change all the 'If' statements in 'Case'. This give more possibitys. Very easy to use. Link to comment Share on other sites More sharing options...
JW Posted January 9, 2001 Share Posted January 9, 2001 'possibillitys' of course. insufficient fingers !!? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8529 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now