How to avoid multiple calls to the same data input method

[black]

Hello,
I know that the issue I'm going to describe is the expected behaviour, but I've not understood how to avoid it (probably different cacti versions: I run Cacti 1.2.26 with Spine 1.2.28).

I've several graphs using the same Data Input Method. let's say a php script that extract several information from the database. At the moment for each graph I've a different rrd, that does the same request to the php script to fetch the same parameters used by the other graphs.

My goal is to have the data input script that fetches all metrics only once and have them "reused" in all RRDs, without repeating the same request multiple times to the same server. Those requests can be very expensive on the target server, and recently I had to increase the max connections on the mysql target db to account for the burst of parallel requests.

Do you have a guide on how to do that?