Re: ANSI mode and logging questions

Srini Raman (srini@anl.liv.usw.com) wrote: : Hello, : I am new to database. I have two questions. : In our system, we need to update two identical databases : , of which one acts as a backup. OnLine data replication does this for you. : 1. We have two sets of data, one which is very important and : the other which is not so important compared to the first one. Presumably this is a different two sets of data, as they were identical just now? :-) : I would like to create the database with unbuffered log : in case of first set of data and I think it's an overkill : for the second set of data. Sounds suspicious. Why isn't it overkill for the first set? : Is there any way to specify to treat few tables as unbuffered : log and others as buffered (pardon me if it's a stupid Q) Yes. Put them in different databases. : I thought of this solution: : create two databases, one for each set and set the log : appropriately. But this creates the possibility of : opening and closing the datasbes frequently (since : you can't open two datasbes at the same time). Why would that be a problem? If it was happening frequently everything would be in cache. If it was happening infrequently the overhead would be infrequent. : Any thoughts... In any case you can access tables in two different databases simultaneously. They must be both logged or both unlogged but you can mix buffered and unbuffered. : 2. What are the advantages and disadvantages (as far as : programming and performance is concerned) in creating : the databse in ANSI mode? advantages: not a lot. (eg ANSIWARN) disadvantages: "slow" defaults (eg repeatable read, unbuffered logging etc) -- graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.