Hi,

The timer event will fire every 1 minute to check for the zip file,
if exist, it will disable the timer to process the database file first
before enabling it back again.

>Just a shot in the dark........but is the timer firing every minute while the file exits? If so, it seem it could be doing the processing over and over until the file is finally deleted. If the processing is not done within 1 minute perhaps this is causing the slowdown.
>
>Greg
>
>
>>Hi,
>>
>>Actually my application just on detection of some file, will unzip the zip
>>file and start posting (seeking, updating and deleting) like the pseudocode
>>below. Whenever it process data, the whole system seem to halt, then fine
>>once the processing is over.
>>
>>Timer_Event() that trigger event every 1 minute.
>>
>> If file exist(zipfile)
>> Do ProcessData
>> endif
>>
>>End Timer_Event
>>
>>
>>Function ProcessData
>>
>> do while file exist(zipfile)
>>
>> if file(zipfile)
>>
>> unzip(zipfile)
>> delete zipfile <--- zip file contain files like file01001,file01002
>> if file(file01xxx) <---- if file01001, file01002
>> process file(file01xxx) to database
>> delete file(file01xxx) after processing
>> endif
>>
>> endif
>>
>> loop
>>
>>endfunc
>>
>>
>>>Without looking at the code or knowing some of your configuration specifics, we can only shoot in the dark...
>>>
>>>>Hi,
>>>>
>>>>I observed that my application when processing data like seeking and
>>>>updating or updating will 'halt' my whole system as seem on the Win9x
>>>>system monitor program, it is actually using up all my processor time
>>>>and other program seem to halt too until my application completed
>>>>the processing. Hence, when my application is running 24x7 day,
>>>>it will cause my system timing to slow down by 15 - 30 minutes.
>>>>
>>>>What is wrong, why normal processing of data will had this effect.
>>>>Is there any way to improve this problem.
>>>>
>>>>
>>>>
>>>>Thank you