This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
3781
Bug reports / Re: SMF bug 4770 (top level menu items should be clickable)
« on April 12th, 2012, 10:31 PM »
Well, that too would work, but then you're getting into the realms of having some button strips that act just as button strips, and some button strips that act as non clickable buttons with dropdowns. Whatever you do, you still end up creating something that does not behave like anything else in its style. Either we give it a unique look (and make it very clear that there are drop items), or we make them more like other menus and make them clickable.
3782
Bug reports / Re: Board order issues
« on April 12th, 2012, 10:25 PM »
No, that means it's not using any index to filter records (because it's using the WHERE to isolate, rather than an index), and then the results are sorted on a filesort.
Just to clarify, when you normally do sorting, you create a temporary table in memory, perform the sort and return results. When you invoke something that has a text column into a sort, it cannot use a temporary table in memory and does so on disk - by comparison this is much slower. (Note that varchar columns only create on-disk tables if there isn't enough memory to do the sorting in RAM, whereas a text column will always generate a filesort)
Just to clarify, when you normally do sorting, you create a temporary table in memory, perform the sort and return results. When you invoke something that has a text column into a sort, it cannot use a temporary table in memory and does so on disk - by comparison this is much slower. (Note that varchar columns only create on-disk tables if there isn't enough memory to do the sorting in RAM, whereas a text column will always generate a filesort)
3783
Bug reports / Re: Pretty URL remarks
« on April 12th, 2012, 09:17 PM »
I can fully understand that, but on the flip side, it does work exactly how you suggest.
The only downside to checking for any URL-like structure is that you can risk changing things that shouldn't be changed, e.g. the URL that controls the page index injection for ... expansion (which is a known bug in SMF implementations)
The only downside to checking for any URL-like structure is that you can risk changing things that shouldn't be changed, e.g. the URL that controls the page index injection for ... expansion (which is a known bug in SMF implementations)
3784
Bug reports / Re: Pretty URL remarks
« on April 12th, 2012, 08:31 PM »
It's certainly possible to do it as a once-run thing, SlammedDime's mod (SimpleSEF) does that if I remember rightly.
I see where you're going with making it faster though, and I think you're right, that it can be made faster.
I see where you're going with making it faster though, and I think you're right, that it can be made faster.
3785
Bug reports / Re: Board order issues
« on April 12th, 2012, 07:48 PM »
There's no best solution at all, only a variety of least worst solutions that all have their up-sides and down-sides to them.
3786
Features / Re: timeformat annoys me...
« on April 12th, 2012, 07:47 PM »
Oh, I see, that makes sense :)
3787
Features / Re: timeformat annoys me...
« on April 12th, 2012, 06:31 PM »
But surely you can't do it only once? If you load French, you load French after you load English... so you need to rebuild it when French is loaded - surely you need to do it just when $template_name === 'index' so that you always rebuild it properly when changing languages?
(That does raise questions for switching languages e.g. for emails but IIRC index isn't used then anyway)
(That does raise questions for switching languages e.g. for emails but IIRC index isn't used then anyway)
3788
Bug reports / Re: Board order issues
« on April 12th, 2012, 06:11 PM »
Don't let yourself be pushed back by it, I'll worry about it :)
3789
Bug reports / Re: Board order issues
« on April 12th, 2012, 04:16 PM »
But I do worry about it :P But really worrying about it at this stage is not a huge deal, we can always fix it up later if we have better ideas :) (Beta is when we really need to worry about performance)
3790
Features / Re: timeformat annoys me...
« on April 12th, 2012, 03:57 PM »
Hmm, I thought India was +5:45, but it seems to be +5:30.
And yes, I did get it confused with time_offset. (Am not at home today but have laptop with me)
Thing is, if we're being correct about suffixes, I'd prefer to be correct across the board ;)
As far as using that array goes, do it in loadLanguage, if the loaded language file is 'index'. It's called only a few times per page, far fewer than timeformat or number_context is.
And yes, I did get it confused with time_offset. (Am not at home today but have laptop with me)
Thing is, if we're being correct about suffixes, I'd prefer to be correct across the board ;)
As far as using that array goes, do it in loadLanguage, if the loaded language file is 'index'. It's called only a few times per page, far fewer than timeformat or number_context is.
3791
Bug reports / Re: Board order issues
« on April 12th, 2012, 03:35 PM »
But that's still a filesort per time it's viewed - and it is an I/O hit that's not very nice. I don't think it's a performance killer but we should be mindful of it. What it might be worth doing is figuring out whether it's worth doing in PHP rather than MySQL.
3792
Bug reports / Re: Board order issues
« on April 12th, 2012, 03:16 PM »
Other than using a filesort on that page >_< But it isn't likely to be MANY calls (other than search engines)
3793
Features / Re: timeformat annoys me...
« on April 12th, 2012, 03:15 PM »since no timezones exist that require a 15mn granularity,
But it's still kind of moot. There absolutely MUST be a timezone set. You can't even call time(), without having a timezone being set because PHP will complain bitterly. Same with strftime, date etc. And given that we already have to do that, it's no biggie to get the user's timezone that they've set, which allows us to calculate the offset relative to server time, including DST, and get it right. IIRC I implemented it so it calculated the time_format and overrode what the user had otherwise set to preserve codepaths.
So I changed my time format but forgot to also set my timezone, and as a result my forum pages were all showing dates that were late by one hour.
No, can't do something specific like that... It would need to be built into the language loader (i.e. load English, and if another language is loaded, unset all English suffixes), and I don't really like the idea.
What you can do, if you want, is implement it as an array, such as:
$txt['day_suffix'] = array(
1 => 'st',
2 => 'nd',
3 => 'rd',
'n' => 'th',
);Or, as previously discussed creating a set of prefixes. But this seems cleaner to me - and you can have it expanded automatically into a normal set of day_suffix_1, day_suffix_2 etc in loadLanguage, when the loaded language file is 'index', and have it automatically unset all of them and build them out of just this array.
3794
Bug reports / Re: Pretty URL remarks
« on April 12th, 2012, 12:49 AM »
The sad reality is that the complex code that is very hard to read and fathom out is the fastest.
3795
Off-topic / Re: Random idea: non-generic default avatars
« on April 11th, 2012, 11:26 PM »
Is Bebas being shipped in Wedge's files? If so, we can certainly use it for this. Would be more apt, really, given everything else.