| 05 Sep 2007 11:33 am |
I have a silly rank Rep: 45  Joined: 03 Nov 2003 Posts: 1,291 | I updated two of the very important queries and added indexes (took a loooong time) accordingly. Hopefully this helps!
---
What a moderator can do to you, I can do to a moderator...
Omnipotent Overlord of MVC | |
 |
| 05 Sep 2007 06:57 pm |
Guardian of MvC Rep: 80 Joined: 06 Jan 2006 Posts: 44,385 OFFLINE | 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.
---
^ top sig made by Sawah <3 | |
| 06 Sep 2007 02:16 am |
I have a silly rank Rep: 45Joined: 03 Nov 2003 Posts: 1,291 | Fixed the RSS feeds.
---
What a moderator can do to you, I can do to a moderator...
Omnipotent Overlord of MVC | |
| 06 Sep 2007 02:22 am |
I have a silly rank Rep: 45Joined: 03 Nov 2003 Posts: 1,291 | 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... 
---
What a moderator can do to you, I can do to a moderator...
Omnipotent Overlord of MVC | |
| 06 Sep 2007 09:50 am |
I have a silly rank Rep: 45Joined: 03 Nov 2003 Posts: 1,291 | 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!
---
What a moderator can do to you, I can do to a moderator...
Omnipotent Overlord of MVCLast edited 06 Sep 2007 10:04 am by Bjarne | |
| 06 Sep 2007 12:41 pm |
Guardian of MvC Rep: 80Joined: 06 Jan 2006 Posts: 44,385 OFFLINE | *looks at my post count*
Sorry Bjarne. 
It’s not my fault I like this site so much though. lol
---
^ top sig made by Sawah <3 | |
| 28 Sep 2007 05:01 am |
I have a silly rank Rep: 45Joined: 03 Nov 2003 Posts: 1,291 | 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.
---
What a moderator can do to you, I can do to a moderator...
Omnipotent Overlord of MVCLast edited 28 Sep 2007 05:02 am by Bjarne | |
| 28 Sep 2007 05:03 am |
The Dog-Mod! Rep: 52 Joined: 28 Dec 2006 Posts: 18,829 | 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
---
 
  | |
| 28 Sep 2007 05:53 am |
UBER 1337 Poster Rep: 23 Joined: 06 Sep 2007 Posts: 1,990 OFFLINE | bob wrote:
hello
billy wrote:
stfu
DAMMIT I HAVE TO WRITE SOMETHING!
| |
| 28 Sep 2007 05:57 am |
UBER 1337 Poster Rep: 23Joined: 06 Sep 2007 Posts: 1,990 OFFLINE | 
| |
| 28 Sep 2007 07:39 am |
Genghis khan Guest | something got DELETED i wonder why that was?
| |
| 28 Sep 2007 12:54 pm |
Guardian of MvC Rep: 80Joined: 06 Jan 2006 Posts: 44,385 OFFLINE | 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
---
^ top sig made by Sawah <3 | |
| 28 Sep 2007 03:07 pm |
........................................ Guest | [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
| |
| 28 Sep 2007 03:08 pm |
........................................ Guest | [quote=7]
| |
| 28 Sep 2007 03:09 pm |
........................................ Guest | 77 wrote:
| |
| 28 Sep 2007 03:44 pm |
Genghis khan Guest | 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!
| |
| 29 Sep 2007 02:28 pm |
Wannabe Rep: 0 Joined: 23 Sep 2007 Posts: 27 OFFLINE | [quote=Genghis khan][quote=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 | |
| 12 Oct 2007 04:17 am |
I have a silly rank Rep: 45Joined: 03 Nov 2003 Posts: 1,291 | 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.
---
What a moderator can do to you, I can do to a moderator...
Omnipotent Overlord of MVC | |
| 12 Oct 2007 04:22 am |
OWNED BY SA-X Rep: 63 Joined: 24 Apr 2007 Posts: 13,669 OFFLINE | Yay.
Thanks, Bjarne.
---
 | |
| 14 Oct 2007 06:19 pm |
Nyarlathotep Rep: 12 Joined: 26 Jun 2005 Posts: 6,920 OFFLINE | I remember the first Lounge.
---
Not dead that which can eternal lie,
And with strange aeons death may die.
- H. P. Lovecraft Join the Order | |
|
Previous Page - Post Reply - Next Page |
»
Feedback
» Official changes topic...
