Newbie: LOGICAL Logs -Reply

Newbie: LOGICAL Logs -Reply Jeff You don't mention whether you are using sql or 4gl. I don't think that order by's can have any affect on the number of logs that are being taken up as they are in no way required for rollback. In 4gl you can obviously use cursors to reduce the size of the singleton transactions that you are dealing with. In sql try summarising into temp tables and joining and selecting out of them rather than doing one huge select. This will reduce the size of the singleton transactions. If you are unable to programmatically workaround the issue then the answer is simply that you do not have enough logs configured for the size of your system. HTH rgds -- -- Peter Tashkoff NZ Kiwifruit Marketing Board Project Consultant/DBA 0064 9 366 1200 Standard Disclaimers apply This posting may not be used by any commercial organisation to vilify another. >>> Jeff Cerrafon <jeff.cerrafon@bellsouth.co.nz> 11/June/1996 10:23am >>> We are running INFORMIX 5.04 ONLINE on HPUX 9.04(HP9000). Do select statements with several table joins or ORDER BY clauses CREATE logical log entries? If they do, is there a quick workaround to avoid LONG TRANSACTION? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Jeff Cerrafon jeff.cerrafon@bellsouth.co.nz ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~