Skip to content

Sessions Table Row Lock and Performance  #643

Open
@MemiMem

Description

@MemiMem

Hello,

We have recently encountered a performance issue with quickFIXGo. We see that when we have considerable outgoing orders our rate of processing of incoming messages decreases significantly. From our testing we see that we slow down our outgoing message processing by 40-50% in such cases. We are on FIX 4.2, using postgres as the message_store and are using the latest version of quickFIXGo.

We have seen no resource issues on our side at all. As such, we are under the suspicion that this might be a logical performance bottleneck.

Looking through, we see that the table sessions contains both the incoming and outgoing seq_num. We speculate that during updates to this table (like store.SetNextSenderMsgSeqNum()) this row is locked and this might be a major factor in the slowdowns that we experience.

EDIT: We are talking about the initiator in this case

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions