Some questions first, to help you get better answers:
1) What is the normal speed for the "clear all fields to empty" operation?
2) Which of the following are you using...
Pessimistic or optimistic locking?
Row or table buffering?
3) What RAM do the using PCs have installed?
4) What is the network operating system?
5) Do you hear the hard drives running on the using PCs when the slowdown starts?
6) Are you using transaction processing?
Your "my data may be not saved for my child table" seems to be a separate problem and we need more details about this too.
My guess for your slowdown problem is that you have object references tht are "dangling" (hanging around because they are not cleared properly) and that they eventually build up, taking up RAM space, until the system is forced to use SWAP space for additional storage.
JimN
>Hi,
> I have a multiuser application. It is about 3-5 users only in 100BASET network with PIII machine. I face a problem that, My application take 2-3 seconds to refresh (clear all field to empty) after it run about 7-8 hours. Again, my data may be not saved for my child table. It happened only after it run a period of time. Any ideas?? What should I check it out??
>
>Thank you