update on this for anyone who is interested.
Ive moved my site to a vps
it does not load in any faster than on my shared hosting acct.
The host has said
"slow speed only happens after a period of time where the site hasn't been used. It removes the tempDB table it creates and then recreates the whole thing which takes quite some time with the number of products you have. Also as it's a single query it is limited by single-core performance"
any advice anyone ? I was hoping that moving to a VPS would increase page load massively !
I have keep alive task enabled and store url correctly set.