Thank you for your input Paul.
My largest table is 30 fields with 50,000 records.
The calcs are not terribly complex; most often they take 3 to 4 values from several tables and perform a common operation on them. One complication is the necessity to do some Immediate IF (IIF) tests within calculations to determine which multiplier to use in given calculation.
The note on C as a compiled language is a good one. It makes sense not to expect as much from the interpreted language. I wonder how they would compare in a head to head test on my calcs.
>How big are your tables?
>
>How heavy are your calculations?
>
>Do not forget that FoxPro doesn't have a native compiler. C/C++ are real compilers. And compiled code is always faster than interpreted code.
>
>After all, FoxPro is written in C... :)
>
>Vlad
>
>>Hello !
>>
>>We have developed a VFP5 program called the Factory Commander that gathers data about a manufacturing process and produces reports indicating production results.
>>
>>The calculation phase of this program takes about ten times longer than our competitors who use C and Smalltalk. We have about 15 related tables and use SCAN/SEEK and SQL Selects to process the data and I believe we are maximizing the Rushmore technology.
>>
>>Any ideas on why our competitors are beating us using a 'database from scratch' in C ?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only