<html><head></head><body bgcolor="#ffffff" text="#000000" link="#000000" alink="#000000" vlink="#000000" marginwidth=10 marginheight=10 topmargin=10 leftmargin=10>Hi,
<br>
<br>i have 2 Functions, one ist called by page visitors (something about 2,000 times / 1 hour)
<br>and the other just by the admin (let say 1 time per hour or per login)
<br>i often get a deadlock error after calling the admin function
<br>yes they try to access the same table somewhere in the function code.
<br>The Admin function can take up to 20-30 seconds and visitor function just 20 to 30 ms
<br>What can i do there? Have i to study a lot about locking tables or something else?
<br>
<br>Thanks for your Help
<br>regards,
<br>Boris</body></html>