> Well, I guess I was not clear in my explanations. > I'm already doing my own locking, that's the problem! > But I'm not sure how to improve it. ... > At which stage the data will be saved it and..... > > that will froze the application because the search/select already get the > database lock.
How about putting the update into in it's own thread and just wait till any locks are released?
