I fixed the speed issues with SQL, mostly. Using prepared queries did it. After that, it was still timing out on pages of users with a lot of posts, but the initial load seems to take about the same time, which is odd. So I changed it to load all pubs on startup, and that 'fixed' it. Not ideal, but we want to eventually load immediately from SQL and get rid of the memory cache anyway, so, this works for now. Just takes a little longer to start up.
And yeah, it's loading far too much when displaying pages. Any given page has like, a kilobyte of data on it. There's no reason for it to load megabytes of data and time out. Once we fix it to only load the data it needs to display, it should be fast and memoryless. I'm suspecting we won't even need Memcached.
That fixed, the only bug I'm aware of, is that newly created comments don't appear on restart. Something isn't saving right. But existing comments show up fine. I'll fix it.
Then, if I don't find anything else, I'll deploy it. Hard to say if it'll be this weekend or next. But it's like, really close.
I think we'd rather keep that one. I can see where you're coming from, wanting more control on what you type. But you can still edit and uncapitalise the first word, after posting. I think capitalising by default makes the feeds look more professional and less text-messagey.
I didn't know what a lot of that meant but this part I heard loud and clear: but it's like, really close.
Awesome!