>>I wish to send this program to someone for a quick review... I had the original code (procedural) which I converted to a class. I made couple of other speed improvements. However, it doesn't seem enough. I'm not sure what else can I optimize.
>
>Maybe you can optimize "logic to check this and that" part. I noticed you're releasıing 2 fields. That makes me think you've default values, procedure running to get those defaults and maybe also some triggers and RI checks which would further slow down all these. Otherwise 16 tables scan...endscan doesn't explain to be as slow as one hour.
>Cetin

Yes, exactly. cEntered_User has GetUserID() as default (database SP to get user id based on machine name) and tEntered_Time is datetime(). If we do scatter, we need to release these two variables, so they would be re-calculated. I switched from scatter to insert fields in almost all the code (left just 3 scatter where we have too many fields to list).