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!!

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).]

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.

'possibillitys' of course.

insufficient fingers !!?