We have developed a specialised order processing application (using Codebook) that now contains a lot of data. The data lives on a file server running NT 4, and the order processing is performed by a workstation.

When we process orders the network slows down as we generate huge amount of LAN traffic by reading lots of records via local views from the server.

Firstly does anyone have any advice for us, our application is growing (data size) but our customer does not particularly want to move to a SQL environment.

Regards
Mark Letheren