I want to know why the machine always hang as the network traffic too busy.

This is a donation/mailing system.
The master donar table is about 35k data,
The donation table is about 37k data,
The subsciption table is about 30k+ data....

PC Hardware config:
Cel. 433, 64MRAM, 8G harddisk, NT 4.0 with SP server. (Server connection is 10/100 mode)

All data Locate at Server.

The system work okey when first time open form and do simply data entry and work.
But it will hang when open new form after a bulk search SQL is successful done..
the result of SQL search result is less than 1k data.

Currently, bulk search take time about 30-40 seconds for 7-8 SQL group by statement.

As here I hear VFP can handle 1M record with easy,
so I would want to know what is req. for 30k+ data!

Thanks and regards,