>We are running on an NT4.0 sp6 server with nt40 and win2000 workstations.
>
>There are probably no more than 6 people in the table at one time.
>
>The application is built on Visual Promatrix. The referential integrity is not working, the queries are slow and the relate to a GIS coverage doesn't work any more as well as reindex command not working.
>
>The indexes for the table is
>
>stand township+range+section+stand
>ostand township+range+section+ostand
>compartno PADL(ALLTRIM(STR(compartno)),2,"0")+township+range+section+stand
>deleted DELETED()
>record_no "A"
>birthyr STR(birthyr)+covertype+fsilv
The index on deleted() may be one of the reasons - perhaps the main reason - the queries are slow. Try to eliminate them, and see whether it affects the speed. See my FAQ #8109 for an explanation, why this may be so.
>The other tables all have similar indexes. The indexes are non structural .cdx's
Non-structural indices can become outdated, if you forget to open them explicitly, when you open the table, in any part of your program. I highly recommend you use structural indices.
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)
