Report Screen Speed Features

As I have mentioned (over and over) speed was a major concern when designing ZP SQL. All of the report screens were modified to add two new features that limit the amount of data requested from the internet. The first is a simple field that limits the maximum number of rows pulled down for a report. By default reports are limited to 100 records. You can edit this value to grab more records. Entering a 0 (zero) in the box effectively turns the feature off. The second new feature is a check box which limits the number of fields that are pulled by each report screen. Because report screens typically include data from both the property database and an application database, there are potentially many fields that could be pulled for every query. Most of the reports, however, include only a fraction of the fields available. So we devised a system whereby a text file holds a list of all the fields each report screen should pull. These lists are shipped with ZP SQL and are initially limited to only those fields included in the default reports. There is a screen in Maintenance where you can edit these lists of fields and add more fields as needed. This system works great but as we soon discovered, speed is not nearly the limiting factor we thought it might be. So now there is an option to turn off field limiting feature in the Personalization Options screen.