Official changes topic...

I updated two of the very important queries and added indexes (took a loooong time) accordingly. Hopefully this helps!

How to post images - Video posting discussion
Image Rules - General Rules

Omnipotent Overlord of MVC

Oh wow, I leave codec at about 3:30 AM codec time this morning and come back to The Lounge just a few hours later. lol

Awesome.

Rise of Shinra

Fixed the RSS feeds.

How to post images - Video posting discussion
Image Rules - General Rules

Omnipotent Overlord of MVC

Restored latest posts on users profiles.

Some might be wondering why, momentarily the front page, latest posts and rss feeds was disabled. This was in an attempt to reduce load on the database while optimizing and figuring out how to re-write the SQL queries without them smashing the database server...

How to post images - Video posting discussion
Image Rules - General Rules

Omnipotent Overlord of MVC

Due to issues I disabled the showing of latest posts on profiles again :/

I have figured out why that particular feature sometimes would cause major slowdowns:

When finding out what the 10 latest posts are by a certain user it would first find all visible posts by that user on the particular site and then sort all these posts according to time before showing only the latest ones. Now this is all fine and dandy, except that there any no indexes for user, visibility and time on the database table: means it will have to sort thousands upon thousends of rows for each hit on profiles pages for users with many posts. I can fix it, but I will wait untill a better time to do it: I need to add a new index - but that is a lengthy process!!! Takes almost 40 minutes!

How to post images - Video posting discussion
Image Rules - General Rules

Omnipotent Overlord of MVC

*looks at my post count*

Sorry Bjarne.
It’s not my fault I like this site so much though. lol

Rise of Shinra

Now it’s no longer possible (hopefully) to post a message that contains nothing but quotes.

Also when you forget end quotes, which would otherwise screw up the signature, it will give you an error message indicating how many end quotes are missing...

Please report any problems (if any) this fix causes.

How to post images - Video posting discussion
Image Rules - General Rules

Omnipotent Overlord of MVC

Bjarne Lundgren wrote: Now it’s no longer possible (hopefully) to post a message that contains nothing but quotes.

Also when you forget end quotes, which would otherwise screw up the signature, it will give you an error message indicating how many end quotes are missing...

Please report any problems (if any) this fix causes.

I hope so

bob wrote: hello

billy wrote: stfu

DAMMIT I HAVE TO WRITE SOMETHING!

something got DELETED i wonder why that was?

Bjarne Lundgren wrote: Now it’s no longer possible (hopefully) to post a message that contains nothing but quotes.

Also when you forget end quotes, which would otherwise screw up the signature, it will give you an error message indicating how many end quotes are missing...

Please report any problems (if any) this fix causes.

Now this is awesome. No more spamming with quotes and now more screwing up the post because we suck at quoting things. XD

Rise of Shinra

[quote=­Cid]

Bjarne Lundgren wrote: Now it’s no longer possible (hopefully) to post a message that contains nothing but quotes.

Also when you forget end quotes, which would otherwise screw up the signature, it will give you an error message indicating how many end quotes are missing...

Please report any problems (if any) this fix causes.

Now this is awesome. No more spamming with quotes and now more screwing up the post because we suck at quoting things. XD

u sure about that

[quote=7]

­

77 wrote:

­

Bjarne Lundgren wrote: Now it’s no longer possible (hopefully) to post a message that contains nothing but quotes.

Also when you forget end quotes, which would otherwise screw up the signature, it will give you an error message indicating how many end quotes are missing...

Please report any problems (if any) this fix causes.

— — — — — — — — — — — — — — — — — — — — — —
­­
to be quiet honest with ya, it don’t really fix that much now does it. eh!

[­q­uote=­Genghis khan­][q­uote=­Bjarne Lundgren­]Now it’s no longer possible (hopefully) to post a message that contains nothing but quotes­.

Also when you forget end quotes, which would otherwise screw up the signature, it will give you an error message indicating how many end quotes are missing...

Please report any problems (if any) this fix causes.[­/quote­­]

— — — — — — — — — — — — — — — — — — — — — —
­­
to be quiet honest with ya, it don’t really fix that much now does it. eh! :­o[­/quote­]­

666EVIL666

Hired new moderators....

On my profile page you can see current moderators, some are more active than others...

For new moderators: you might (or might not) need to log out then log in again for the change to take effect.

How to post images - Video posting discussion
Image Rules - General Rules

Omnipotent Overlord of MVC

Yay.

Thanks, Bjarne.

I remember the first Lounge.