PokerTracker

good evening, to improve the loading of the custom stats in the HUD I understand that you have to save at cache those that do not have indexed columns such as stats vs hero and defragment the hard drive
according to the guide.
Any more solutions? Could you create several databases that are part of the default database and thus activate the ones you need to not use a lot of memory? And if you can, how should I do it?

You can keep hands in separate databases if you wish:

Guide: Database Management

You can tell PokerTracker 4 which database(s) to use for HUD statistics via 'HUD -> Edit HUD Options -> General Settings -> Advanced'. I cannot quantify any performance changes however as far as retrieving data for the HUD goes things might be a little slower using multiple databases but if you're using cached stats then it shouldn't cause much of a problem.