If you calcs are not very complex and your competition is ten times faster, I think you should reanalyse your db model. Also analyse the dynamics of data changes. Maybe you can work with offline tables? Tip: a physical sorted table is scanned dozens of times faster than an ordered table (especially on network app).
Vlad
>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.
Previous
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