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 :D

[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 Plomp]

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 :cute:

[sabrewolf]

i don't know lotus domino... but my general experience with lotus (notes) databases were... well... well... uhm... http://www.dvbboard.de/ubb/pukey.gif http://www.stopstart.fsnet.co.uk/smilie/pukeface.gif http://www.stopstart.fsnet.co.uk/smilie/puke.gif

not sure lotus is free really. mysql is :)

[Robert Plomp]

Lotus Domino is perfect if programmed by a good programmer (me :cute:)

It's much more then simple mySQL, better security, better workflow, better database system, better document management, better everything.

The thing is that it's so complex that you need a professional to do it (me :cute: )

Just got my job contract extended by 6 months.
All drink a beer on me!

[Solver]

Ha :p. I was faced with the task of setting up a Lotus Domino/Notes network for databases. Took me some time to figure out how the thing works, but once I did, I must say I was very pleased at how it's made :b:.

[Robert Plomp]

If you need any help, I'm happy to give some!
The problem for Lotus is that it is very un-microsoft.
Microsoft users won't feel at home using the program.
But a good programmer should be able to create a UI in which you will feel happy. For sure if you access the appliation through the internet.

But that makes Notes platform independant.
Unix, Linux, MS, Mac, AS400, RS6000........!

[Solver]

Un-Microsoft? What are you talking about? Those databases are customized using code that is, essentially, Visual Basic.

Yes, well, the hardest part was the beggining, figuring out the authorization system, how and when replication takes place, that sort of stuff. After you mess around some, it becomes pretty pleasant.

[Robert Plomp]

You're obviously talking about a web interface on a domino-server.
In a web-interface you can drop all html/dhtml/javascript/java/vbscript/xml you want.
It's just a webpage.

I'm talking about the Notes Client.
The notes client doesn't support vbscript.

how and when replication takes place

Replication..... one of the killer features Lotus brought up and the rest copied it.....
Still think domino-replication is superior to any other kind.

[Solver]

Not vbscript. But Notes databases can be enhanced by Visual Basic-style codes.

Replication is smooth in Domino, very much so. As well as handling databases that are being filled in from several computers :b:.

I remember now, Lotus was one of the pieces of software I actually heard of a loooong time before I saw it.