What's the easiest way to cache a resultset from a MySQL database? I'm using hikaricp to create a report system for my server but because I'm closing the connection, the resultset it getting closed as well. thanks in advance <3
#Caching MySQL ResultSet
spiral turtle
warm wolf
Create a class that stores the data you need
spiral turtle
Create a class that stores the data you need
is creating a class for it more efficient than using a cachedrowset?
classes are probably easier tbf
warm wolf
Not sure
delicate wedge
is creating a class for it more efficient than using a cachedrowset?
dont use cachedrowset
as it is like a resultset
which is not closed when the statement is closed
this is the only difference
low ridge
