single connection to multiple connections, help

Posted in 1996

ccliu — 23 Nov 1996 15:24:37 GMT — source: Informix-list mailing list archive (1991-1998)

: Hi Net, Currently, our project is using single thread connect to DB. And we are going to use 9 current connections . I know current users will cause some problem the single connection won't has. For Example, if one stored procedure use "new = MAX(fieldname) + 1;" statement, if two users access this stored procedure, then one user will get the wrong new value. Can someong give me some advices when switch from single connection to multiple connections. What important things I should be aware of. Fro example, the Locking strategy, Application logical problem.... Table INSERT/UPDATE/DELETE problem...... (I have to use Select ... For Update instead of just Update...) Thanks. please reply to sss@bart.sdit.com.tw Scott sss@bart.sdit.com.tw PS, we are using INFORMIX-OnLine Version 7.13.UC1 on HP-UX hag B.10.01 D 9000/856.