Hi,
i have 2 Functions, one ist called by page visitors (something about 2,000 times / 1 hour) and the other just by the admin (let say 1 time per hour or per login) i often get a deadlock error after calling the admin function yes they try to access the same table somewhere in the function code. The Admin function can take up to 20-30 seconds and visitor function just 20 to 30 ms What can i do there? Have i to study a lot about locking tables or something else? Thanks for your Help regards, Boris |