Inconsistent results from database calls
Hi all I was wondering if anyone would be able to come up with some possible ideas as to why my application is inconsistently retrieving data from a database. I have an application that is pulling information from a database. These calls can be made repetitively pulling the same information over and over again. The quandry that I am faced with is why the application would pull the right data most of the time, but occasionally not pull the correct values.
I have consided the following:
blocking - all of the calls are read only and scroll insensitive so I doubt this is the case
Limited number of connections
Seems like apossibility but then I would expect an error to be thrown.
Actions happening to fast
I was thinking perhaps the cycle is completing before everything has had a chance to finish the last set - is that a possibility ?
I can't post the code, so I am just looking for any general thoughts or ideas on the topic, if nothing thanks anyways.
