Re: temp table with no log is LOGGING!

SOPCZAKL@crl.aecl.ca (Lauralee Sopczak) wrote: >Hi All, >We are using online 5.01 and have a non-ansi database. We have a batch >program written in ESQL/C (version 5.01) which moves data into temporary >tables (created with no log) to work on. However we have observed that >logging does occur. It is seriously impacting our performance. Has anyone >seen this before and/or have any suggestions as to what we can do to fix >this logging problem? If anyone is experiencing similar problems contact us >and maybe we can troubleshoot together. When you use no log option Informix will no longer log individual records but it will still log every extent allocated. As there is no way to specify extent size for temp table a new extent is created every 4 pages. To work around this explicitly create temp table with required extent size. ----------------------------------------------------------------------------------------------------------------------------- Rafal Czerniawski Dataspace Consulting Pty Ltd rafal@dataspace.com.au Checkout our Database and Data Managment Resources page: http://www.dataspace.com.au/resource.html