Capture a database caracteristics for representative load testing?

[joseph...@gmail.com]

hello

Quite often one has many customers, each with its own database, and it's pretty hard to build a representative load testing environment.

I thought that there should be some "database data distribution capture tool" or similar, but i haven't found any.

Since you have quite some experience in DBs, do you know of any such tool?

If not i guess jOOQ would make a good basis for such a tool... suspense ;)

cheers

joseph

[Lukas Eder]

Hi Joseph,

We don't have anything out of the box. It would be interesting to build something completely jOOQ based, of course, but our roadmap is already full with other priorities :)

Personally, I don't think load testing is something that is worth doing with only one part of the system in isolation. You probably have a few layers in front of the database, which contribute to the load in ways that are difficult to foresee with database testing alone (e.g. N+1 problems, to name the most obvious). For that purpose, I would recommend https://gatling.io/.

I hope this helps,

Lukas

--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/4fa69174-3800-4c55-aac2-3e7091fef21b%40googlegroups.com.

[joseph...@gmail.com]

Hi Lukas

Thanks a lot once more :)

Regarding a jOOQ based solution, let's see if at work we go for creating one (closed source) or if i find the time to do so on my own (open source this time).

And thanks for letting me know you aren't aware of out of the box tool for this.

Regarding the need to know the wider context, we agree, but still having the database's data distribution is required.

Cheers,

joseph

On Monday, March 9, 2020 at 9:27:24 AM UTC+1, Lukas Eder wrote:

Hi Joseph,

We don't have anything out of the box. It would be interesting to build something completely jOOQ based, of course, but our roadmap is already full with other priorities :)

Personally, I don't think load testing is something that is worth doing with only one part of the system in isolation. You probably have a few layers in front of the database, which contribute to the load in ways that are difficult to foresee with database testing alone (e.g. N+1 problems, to name the most obvious). For that purpose, I would recommend https://gatling.io/.

I hope this helps,

Lukas

On Sat, Mar 7, 2020 at 7:01 PM <joseph...@gmail.com> wrote:

hello

Quite often one has many customers, each with its own database, and it's pretty hard to build a representative load testing environment.

I thought that there should be some "database data distribution capture tool" or similar, but i haven't found any.

Since you have quite some experience in DBs, do you know of any such tool?

If not i guess jOOQ would make a good basis for such a tool... suspense ;)

cheers

joseph

--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to jooq...@googlegroups.com.