Wedge

I will at some point, but it probably won't be today.

At a glance, getBoardTree looks reasonably sane?

It made me feel like something in my life hasn't been a waste, you know? I feel like a lot of the last 10 years has been for me right now. Shallow? Perhaps, but it made me feel good if only for a passing moment.

That's the thing, it's not something we put a key on. The flag is simply to identify whether or not we do a second query to get the extra polls or not - if the flag is empty when we get the topic's info, we know we don't have to load a poll or anything, but if it's not empty, we know we have more work to do.

In terms of indexing, we never query based on 'has poll/has no poll' so it doesn't need to be added to any of the indexes on the topics table.Actually it doesn't. The VARCHAR() is defined as the character length of the string, but internally uses the extra byte(s) to indicate byte length - since character length and byte length are not necessarily joined, it has to know the byte length in order to work out where the row is. The 65535 limit is a hard limit - but only because a MyISAM table is only permitted to have 65535 bytes per row, not for any other reason.

In our case, VARCHAR(255) means 255 characters but that it will probably need a 2 byte length in UTF-8 because 129 Japanese characters, for example, will overflow 255 bytes in physical length.

This is ultimately where the performance penalty of using UTF-8 comes in, where you're expressly not using a single byte character set where you don't have to worry about byte length vs character length.Such as?

MY POST COUNT :D

That is all. Have a good day.

There's an interesting suggestion been made, that the preparsing essentially should happen twice.

What I'm thinking it might be simpler to do is perform the expansions that would normally occur, then do validation on length, so not quite full preparsing. Mind you, it does depend a lot on the comments about, about what signatures 'need'.

OK, I'll add this in a bit (hopefully later today depending on how things work out). My plan of action is to do as I did in SimpleDesk, create a new template block with the <noscript> message (and an icon, just for the sake of nicety) and inject it into the skeleton above all the content.

I studied it briefly in the 1990s but don't remember very much except my amusement at discovering the word for cupboard is similar to a profanity.I think it makes a difference having them in use vs having them attached to a thread, really.