"Nik" <XLPizza@xxxxxxxxx> wrote > I have an application that executes an INSERT statement every second or > two. In my old design this data was inserted into one table. However, I > changed the design to have one table with multiple partitions. Now when > I run the application it runs for some random amount of time (random > number of INSERTs) and then it gets stuck at the INSERT query and it > never finishes (at least not in some reasonable time - aka few hours). > If I restart the application it continues inserting the data normally > for a while before getting stuck again. > Do you do INSERT concurrently? Can you post a self-contained example to reproduce it? Regards, Qingqing
