There is no difference in the engine by edition.
Using SQL Express I am seeing certain insert commands not executing in real time.
They are executed after the main process, which has its own set of select/insert statements, is done and closes its connection. All of the operations work against the same database and tables using the same connection global in VB.NET. No data is lost. The 'cached' commands execute from subroutines of the main process, with their own connection object. Transactions are used but committed and the connection closed after each insert in the subroutine. Does SQL Express not support this simultaneously?
We still don't know how you have concluded that "some of the table inserts are done after the main process completes."
With the information you have shared so far, the only reasonable explanation is that the application is behaving differently in the two cases. There is certainly no difference between Express Edition and other editions that can explain this.
However, my experience from having answered questions in forums is that the real answer is often something completely different, and which becomes apparent once we get a more detailed description of the situation.
Sign in to comment