RE: Newbie: LOGICAL Logs -Reply

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Contact your mail administrator for information about upgrading your reader to a version that supports MIME. ------ =_NextPart_000_01BB5768.112A49E0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit The comment that order by will not affect your logical logs may be wrong depending on the engine you are using. If you are running 7.12 and you are not using a dbspace defined as a temp dbspace for temp tables you will find temp tables being used for order by clauses will be logged. If your sql statements are returning a large number of rows this could be a big problem. (As we once discovered.) Russ... __________________________________________ Russell P. Kahler russell@oncontact.com (414)375-6540 W67 N250A Evergreen Blvd. Cedarburg, Wi 53012 ___________________________________________ }---------- }From: Peter Tashkoff[SMTP:TASHKOP@kiwi.co.nz] }Sent: Tuesday, June 11, 1996 1:27 AM }To: jeff.cerrafon@bellsouth.co.nz; informix-list@rmy.emory.edu }Subject: 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 }~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ } } } } } ------ =_NextPart_000_01BB5768.112A49E0--