Update On Today's Maintainance

[MarkG]

The following occured the 7 hours

- database maintainance and backup
- 50k posts moved off main post sql table
- a couple more PLUS benefits implemented

currently deleting some spam from the off-topic archive

we've still got a lot of stuff to do to face the server load issues....

[Solver]

What benefits ?

No plans as of yet to switch to a faster database engine? SQL probably isn't the perfect choice given the size of our database.

[MarkG]

see the plus news & support thread

[Last Conformist]

The "You could have an avatar this big!" but looks real good when avatars aren'y showing up.

[sabrewolf]

solver:
faster than SQL?

the queries may be suboptimal, but SQL surely is the fastest way for acquiring any dynamic data...

[Solver]

While queries are used quite a lot of the time . Searches, edits, etc. I think that a more powerful database engine works better with the size such as our database.

[MarkG]

that's why we are reducing our database size

[sabrewolf]

i just presume interfering too much in to the queries would make an version upgrade of vBulletin too much work.

i do however see some possible improvements. 37 queries is quite a lot of just 6 posts
(i presume: 1 for thread, 1 for each post (was like that when i looked at an old vB version), 1 for each user (sig+avatar), 1 for each civgroup, a few for the the forum hierarchy (Apolyton CS Forums > Miscellaneous > Apolyton/Community > Update On Today's Maintainance), and the rest for statistical stuff and the forum styles)

[Enigma_Nova]

Sounds murderously inefficient.
Is that why the reply page loads slower than dialup?

[sabrewolf]

mine were just assumptions.

markg, speaking of SQL: any chance of running some custom queries for more stats à la rasputin's monthly lists? of course they are reviewed by an admin and select statements will completely suffice

[MarkG]

37 queries is quite a lot of just 6 posts

the showthread and forumthread pages are fine. if you see the "page generated in" numbers at the bottom of pages you'll see that it's usually under 1 sec, sometimes less than 0.3 secs

the issue is with search related things: new posts, my threads, phrase searches, etc

[Straybow]

And most of that time is PHP (eg, 0.215 sec 85% PHP 15% MySQL with 33 queries)

[Skanky Burns]

Originally posted by MarkG
currently deleting some spam from the off-topic archive

All those +0's, wasted.

[joncha]

My spams! My beautiful antique spams!

[Robert]

My spams! My beautiful antique spams!

Even for internet-standarts spam from jan 2003 is not antique

SQL surely is the fastest way for acquiring any dynamic data...

Lotus Domino