Environment versions
Network:
Windows 2003 Server
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only