I currently have a pretty basic data application that I intend on adding a good deal of functionality. The application is a windows form app using a an access database connected through the oledb method.
Everything works fine, until the iterations are extended to very large numbers. For example, it seems to only pause a second with around 10,000 iterations, but at around 50,000 it freaks out and stops responding for approximately 30 seconds.
The events that are problematic are simple for loops, where they may be needed to repeat a very very large number of times. I could use a different type of algorithm that would require a smaller number of iterations, but this would decrease the quality of my data greatly.
I'm not looking for a specific answer, just some ideas or direction to speed up this event or at least make it where the user doesn't feel this effect.