Re: isolation level

On 15 May 97 at 20:36, Oscar Goldes wrote: > Is there any "rule of thumb" about which isolation level to use when > using Informix SQL? I know, it all depends on the application, but > what is the "usual" level for a client-server system? Can it be > commited read, or must it be higher or lower? Of course, there are > special cases when another level shoul be used. What is the impact > over performance of using too high a level? Many thanks COMMITTED READ is fine as a rule of thumb. My experience is that you can have an "acceptable" level of degradation with all other levels except for REPEATABLE READ, which can (in the right circumstances) club performance into submission... :-) All the above depends on the volumes of data and complexity of SQL, YAMMV, #INCLUDE <disclaimer.h>, etc. -- Ciao, Billy Nose to the ground and ear to the grindstone in: Kuwait City Help fight crime in South Africa: http://www.robkaplan.org.za/