mysql persistence layer performance issues

Hi,

We've had the same problem and already posted some info on the queries that are causing it on this mailing list. We did have the problem a lot sooner, though, around 500 records.
Right now, we're working on our own implementation of the persistence layer in Java, speaking directly to the db.


Bye,



Koen Vanderkimpen

Connect:





From:        "Dr. Kevin Hunt" <[hidden email]>
To:        [hidden email]
Date:        06/07/2012 16:52
Subject:        [ops-users] mysql persistence layer performance issues

---

We are using orbeon forms with mysql persistence layer.  But now that we have about 3000 forms, we are seeing performance issues with the parsing of the XML to populate the summary screens.  Has anyone else seen this issue, and is there a work-around or tuning that can be done?

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: [hidden email]
For general help: [hidden email]
OW2 mailing lists service home page: http://www.ow2.org/wws

	Overeenkomstig de bepalingen inzake de vertegenwoordiging van de vzw in haar statuten, kan enkel de gedelegeerde bestuurder, de algemeen directeur of zijn uitdrukkelijke lasthebber verbintenissen aangaan namens Smals. Indien dit bericht niet voor u bestemd is, verzoeken wij u dit onmiddellijk aan ons te melden en het bericht te vernietigen. Conformément aux dispositions relatives à la représentation de l'asbl dans ses statuts, seul l'administrateur délégué, le directeur général ou son mandataire exprès est habilité à souscrire des engagements au nom de Smals. Si ce message ne vous est pas destiné, nous vous prions de nous le signaler immédiatement et de détruire le message. According to the provisions regarding representation of the non profit association in its bylaws, only the chief executive officer, the general manager or his explicit agent can enter into engagements on behalf of Smals. If you are not the addressee of this message, we kindly ask you to signal this to us immediately and to delete the message.

Kevin,

Any way you can share the changes?

Thanks,

-Erik

On Wed, Jul 18, 2012 at 1:12 PM, Dr. Kevin Hunt <[hidden email]> wrote:

we solved the problem by reformatting the way the selects were constructed.  Plus one index.

Working very quickly again.

On Mon, Jul 9, 2012 at 3:24 AM, <[hidden email]> wrote:

Hi,

We've had the same problem and already posted some info on the queries that are causing it on this mailing list. We did have the problem a lot sooner, though, around 500 records.
Right now, we're working on our own implementation of the persistence layer in Java, speaking directly to the db.


Bye,



Koen Vanderkimpen

Connect:





From:        "Dr. Kevin Hunt" <[hidden email]>
To:        [hidden email]
Date:        06/07/2012 16:52
Subject:        [ops-users] mysql persistence layer performance issues

---

We are using orbeon forms with mysql persistence layer.  But now that we have about 3000 forms, we are seeing performance issues with the parsing of the XML to populate the summary screens.  Has anyone else seen this issue, and is there a work-around or tuning that can be done?

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: [hidden email]
For general help: [hidden email]
OW2 mailing lists service home page: http://www.ow2.org/wws

	Overeenkomstig de bepalingen inzake de vertegenwoordiging van de vzw in haar statuten, kan enkel de gedelegeerde bestuurder, de algemeen directeur of zijn uitdrukkelijke lasthebber verbintenissen aangaan namens Smals. Indien dit bericht niet voor u bestemd is, verzoeken wij u dit onmiddellijk aan ons te melden en het bericht te vernietigen. Conformément aux dispositions relatives à la représentation de l'asbl dans ses statuts, seul l'administrateur délégué, le directeur général ou son mandataire exprès est habilité à souscrire des engagements au nom de Smals. Si ce message ne vous est pas destiné, nous vous prions de nous le signaler immédiatement et de détruire le message. According to the provisions regarding representation of the non profit association in its bylaws, only the chief executive officer, the general manager or his explicit agent can enter into engagements on behalf of Smals. If you are not the addressee of this message, we kindly ask you to signal this to us immediately and to delete the message.

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

Yep, we are working on documenting it now.

On Thu, Jul 19, 2012 at 1:54 AM, Erik Bruchez <[hidden email]> wrote:

Kevin,

Any way you can share the changes?

Thanks,

-Erik

On Wed, Jul 18, 2012 at 1:12 PM, Dr. Kevin Hunt <[hidden email]> wrote:

we solved the problem by reformatting the way the selects were constructed.  Plus one index.

Working very quickly again.

On Mon, Jul 9, 2012 at 3:24 AM, <[hidden email]> wrote:

Hi,

We've had the same problem and already posted some info on the queries that are causing it on this mailing list. We did have the problem a lot sooner, though, around 500 records.
Right now, we're working on our own implementation of the persistence layer in Java, speaking directly to the db.


Bye,



Koen Vanderkimpen

Connect:





From:        "Dr. Kevin Hunt" <[hidden email]>
To:        [hidden email]
Date:        06/07/2012 16:52
Subject:        [ops-users] mysql persistence layer performance issues

---

We are using orbeon forms with mysql persistence layer.  But now that we have about 3000 forms, we are seeing performance issues with the parsing of the XML to populate the summary screens.  Has anyone else seen this issue, and is there a work-around or tuning that can be done?

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: [hidden email]
For general help: [hidden email]
OW2 mailing lists service home page: http://www.ow2.org/wws

	Overeenkomstig de bepalingen inzake de vertegenwoordiging van de vzw in haar statuten, kan enkel de gedelegeerde bestuurder, de algemeen directeur of zijn uitdrukkelijke lasthebber verbintenissen aangaan namens Smals. Indien dit bericht niet voor u bestemd is, verzoeken wij u dit onmiddellijk aan ons te melden en het bericht te vernietigen. Conformément aux dispositions relatives à la représentation de l'asbl dans ses statuts, seul l'administrateur délégué, le directeur général ou son mandataire exprès est habilité à souscrire des engagements au nom de Smals. Si ce message ne vous est pas destiné, nous vous prions de nous le signaler immédiatement et de détruire le message. According to the provisions regarding representation of the non profit association in its bylaws, only the chief executive officer, the general manager or his explicit agent can enter into engagements on behalf of Smals. If you are not the addressee of this message, we kindly ask you to signal this to us immediately and to delete the message.

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws