AFAIK, the whole CDX file have to be downloaded from the server to the client machine on each query, so the bigger it is, the slower the query. Reducing the table size will greatly help optimizing the query time as the CDX will get smaller.

>>1) You say the program is used in several states is this using their own local server or pulling the data over the net.
>
>Pulling over the net, so I know there is a certain amount of performance lost there