hey so I just made this site its a
National Church Directory
Shows churches all over the usa.. made it from a CSV that I imported.
Its not bad data and I have single pages set to display a google map to the church.
There are approximately ten custom fields along with the post that store and display
Street, city, State, Phone, Email, Website, ... no big chunks of text
AND even The_Content is just a single sentence not a lot of data...
Comes out to a 175MB WordPress DB from original 50mb CSV
Each post is stored in State>Town .. Cat
As you can see there are so many cats and posts even.
When I put in a sidebar menu List only the Parent State Cat the server will choke with ran out of memory.
If i take out that menu it will work to some extent if I view a single page or subcat of City....
LOAD IS WAY TOO HIGH... there is no way to rely on SuperCache because you cant even load the page the first time to cache it...
I think this site has a lot of potential but I cant afford to spend $500 a month on a dedicated server I only have a shared account on a real good host..
I am considering some type of HTML Export and running it as static files or... Maybe using the original CSV if i can write code to search and display state>city and posts... but that means editing and allowing comments is not a real option.
SO any help ... greatly appreciated.