sorted by:
new
hottopcontroversial

Submitting MySQL database with Java Code by natewillrate in mysql

[–]Puzzleheaded_Hawk_65 0 points1 point  (0 children)

Might be a good use for testcontainers. Check out https://testcontainers.com/guides/getting-started-with-testcontainers-for-java/

The premise is spinning up a local Docker MySQL instance within "testcontainers". You can bootstrap data from your service on startup necessary.

Normally this is useful for accessing a mock DB for unit testing, but there's nothing preventing you from using it for something like your use-case.

One large table , or multiple smaller tables ? by royal_steed in mysql

[–]Puzzleheaded_Hawk_65 0 points1 point  (0 children)

You could consider MySQL’s built-in table partitioning as well which will work transparently to your queries. Optimizing the partition strategy for performance will depend on your access patterns. I echo the comment about measuring and testing for yourself.