John Smith wrote: > Well from what I can tell is that when the application executes several > commands in a row very quickly I get the deadlock error. The type of command > I am executing on is a Stored Procedure that accesses several tables at
How are you executing commands? > once. Should I change the Stored procedure into a View? So I can duplicate > the error by executing very short executing statements one after the other. What is doing the SP? Only select (if you're able to remake it to view)? Sounds really weird, that only select can do deadlock. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider