Re: performance with mysql / file-caching / hash reference on demand

As you have implemented now all the cool ideas already given you might consider Stored Procedures. I‘m pretty sure that this will give another performance boost. It might be also worth to take a look at all the funny params in your my.cnf. Regards, Karl

«The Crux of the Biscuit is the Apostrophe»

Comment on Re: performance with mysql / file-caching / hash reference on demand Download Code

Replies are listed 'Best First'.
Re^2: performance with mysql / file-caching / hash reference on demand by derion (Sexton) on May 03, 2021 at 23:29 UTC
This is new to me and after some reading looks like a simple and good way to make things faster. Thanks for that!	[reply]
Re^3: performance with mysql / file-caching / hash reference on demand by karlgoethebier (Abbot) on May 04, 2021 at 06:22 UTC
De rien. You may consider partitioning as well. But it is pain in the ass to find the right strategy. «The Crux of the Biscuit is the Apostrophe»	[reply]