Optimising performance over the InternetΒΆ

Applications intended to work over the Internet should be designed to minimise file access.

  • When records are read sequentially from a Sculptor keyed file, use batch file read mode wherever possible, rather than reading each record singly. Batch file read mode is only suitable if the records are not locked, or only locked occasionally. A typical example of a suitable file is the driving file in a report.

  • Avoid using a file as the source object for a table. Performance will be much better if the data in the records is read into arrays when the program starts using the batch read feature. See Tables, Table source object.


RELATED TOPICS

Servers

Running Sculptor programs on a server

Sculptor keyed files