Re: HELP: Long (lasting) transactions?

> >: Informix? Is there anyone who may wish to caution us on >: any potential problems that such long lasting >: transcations would present. I for one, thought that >: there could be problems with tranaction log files. > >It's a bad way to design an application if you want portability. Even >if you use it in such a way that it does not impact Oracle, there are >bound to be implications for other database applications (eg the amount >of disk you need for Logical Logs with Informix-OnLine). > Currently we have a C program that can potentially contain a large number of transactions. Under Informix Online 5.0, it has been giving up a lot of problems. There is one transaction file that contains over 1500 entries. The problem we seem to be running into deals with the blob spaces. We constantly receive the "Cannot close blob" error. We find ourselves increasing the size of the blob spaces over and over again. If your transaction does not write to blob spaces, Informix should be able to handle the transaction; however, if your transaction contains a number of updates to blob spaces, BEWARE, you may encounter a number of problems. -- ============================================================================ _/_/_/_/ _/_/_/_/ _/_/_/_/ John C. Sinues _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ Inc. _/_/_/_/ _/_/_/_/ _/ eMail: sinues@prc.prc.mrms.navy.mil _/ _/ _/ _/ Phone: (804) 498-5666 _/ _/ _/ _/_/_/_/ Fax: (804) 498-5670 ======================================= | "...life is robust and meant to be | lived, joyfully...but not perfectly- | except by accident." ============================================================================