I have a simple query that gets a list of inventory items. It is from a single table.
As I read each line returned I make a call to subroutine that calculates the items that have been allocated or sold from the inventory lot and calculates the remaining value to display in a grid that lists the items and available inventory. I was wondering if the frequent reading of the files in the VB subroutine is causing the problem. The sub routine is also just calling a single table.
Does SQL run into trouble with frequent reads to a table (the allocated or sold table) while reading another table (inventory lot table)?
Everything works fine normally but on some occasions the SQL server returns time out and other times returns incomplete lists or just crashes the system. Code is written in VB.net. Process is run from VB.net code and is not a stored procedure on the server.
This only happens once in a while and not all the time which complicates figuring it out.
Any thoughts would be appreciated.