>I was hoping you wouldn't say that :-)
>
>Thanks,
>
>larry
Unfortunately, it is correct. My forms (based on the Visual Extend framework) started to work very slow with 60,000 records (the table was the child side of a parent-child relationship). And I expected the form to work progressively slower, with more records.
Changing to a view made the speed reasonable again. Also, with a reasonably optimized (partial Rushmore Optimization, of course!) query, the time doesn't depend on the size of the table.
Since creating forms based on views requires some changes (in this framework - CodeBook works with views from the very start), and therefore some additional work, I decided to switch to views as soon as I got above ca. 20,000 records (that is the reccount(), not the number of records to be seen at once).
Also check by FAQ on RushMore Optimization.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
