IUG News

Aktuelles von der IUG.

 

IIUG - Informix News
IIUG Forum: IDS Forum
  • Re: SELECT while being UPDATEd?
    I hate bugs... they annoy customers and they annoy me ;)
    So I try to chase them as much as possible. The only thing worse...
  • Re: SELECT while being UPDATEd?
    Thank you all for your helpful and informative comments.

    Since I left things with a sort of accusation (NOT from me) that there was an...
  • Re: Rss impacting performance
    > On 25 Aug 2016, at 01:24, CHALLENGER212 ABDERRAFI <abderrafi212@gmail.com>
    wrote:
    >
    > Hi, I have an informix Primary 11.7 database in Windows 2008 R2...
  • Re: SELECT while being UPDATEd?
    Not sure exactly what is expected from your post and the discussion that
    followed.... comments inline

    On Thu, Aug 25, 2016 at 11:19 PM, DAVID...
  • Re: SELECT while being UPDATEd?
    Couldn't this be beaten with simple logic?

    Using explicite NEW and OLD references makes it clear which state of the=20
    data is meant (and give...
  • Re: SELECT while being UPDATEd?
    Hi, David.

    I would also suggest a good look at the trigger event definition.

    Please take a look at my last IIUG presentation, named

    "Don't...
  • Re: SELECT while being UPDATEd?
    Art,

    Thank you, once again, for your (always) helpful response.

    The problem is exacerbated by the fact that the "colleague" to which I
    referred is...
  • Re: SELECT while being UPDATEd?
    David:

    You are correct. Your colleague is dead set on making Informix look bad. It
    is most definitely NOT broken since it is working exactly...
  • SELECT while being UPDATEd?
    A colleague created an update trigger on a table A. This trigger invokes an
    SPL that INSERTs a new row in table B. Some of...
  • Re: use of dbspaces?
    Yes it can matter in certain situations. Just off the top of my head:

    1. Inserts into tables partitioned by round robin are generally faster...