Re: from SE to Online: Experience??

Posted in 1994

DoctorQ Komputery i Programy — 31 Oct 1994 14:24:04 GMT — source: Informix-list mailing list archive (1991-1998)

If you port application made for SE you should set Online to be most simillar to SE: - use 'set isolation to dirty read' in the begining of application - set lock mode to row for any table with concurrent use: 'create table ... ( .. ) lock mode row', or 'alter table ... lock mode (row)' - remember use 'update statistics' regularly - add command for Online shutdown to your shutdown script Good luck! Michal Hobot doctorq@sam.nask.com.pl