Optimizing perspective is tricky. Almost everything that happens is executed on the gateway, so things you wouldn't expect can have an impact. If you're running your DB on the same machine as the Gateway, or using VM's and not insuring that your Hpyervisor is configured correctly, you can see poor performance.
I would avoid storing large datasets in a tag. Databases are built for that type of workload, and in my experience there is no performance gain here. I am not suprised that you haven't seen much if any impact here.
Also, rember that Ignition uses Jython, and many times where outside of Ignition you would use a python package to accomplish some things, inside of Ignition there is almost always a Java alternative. This also means that there are some optimizations that have been builtin. For instance chartComponent.chart is more performant than chartComponent.getChart().
Here is a link to a post with some good information: