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