05-07-2004 20:57									#1
	Update On Today's Maintainance Support Apolyton, buy Galactic Civilizations: Deluxe Edition

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....

	05-07-2004 21:01									#2
	Support Apolyton, buy Galactic Civilizations: Deluxe Edition

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.

	05-07-2004 21:09									#3
	Support Apolyton buy from Amazon

see the plus news & support thread

	05-07-2004 22:09									#4
	Support Apolyton, buy Galactic Civilizations: Deluxe Edition

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

	05-07-2004 22:15									#5
	Support Apolyton, buy Alpha Centauri

solver:
faster than SQL?

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

	05-07-2004 22:28									#6
	Support Apolyton, buy Civilization: The Boardgame

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.

	05-07-2004 22:33									#7
	Got spare money?

that's why we are reducing our database size

	05-07-2004 22:53									#8
	Support Apolyton, pre-order Civilization IV

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)

	05-07-2004 23:50									#9
	Support Apolyton, buy Galactic Civilizations

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

	05-07-2004 23:54									#10
	Get a bigger avatar today!

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

	06-07-2004 00:03									#11
	Support Apolyton, buy Galactic Civilizations

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

	08-07-2004 06:39									#12
	Increase Your PM Length

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

	08-07-2004 07:04									#13
	Support Apolyton, buy Galactic Civilizations: Deluxe Edition

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

All those +0's, wasted.

	08-07-2004 10:16									#14
	Enter the AD-FREE zone

My spams! My beautiful antique spams!

	08-07-2004 10:44									#15
	Support Apolyton, buy GURPS/ Alpha Centauri

quote: My spams! My beautiful antique spams!

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

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

Lotus Domino

	08-07-2004 17:13									#16
	Increase Your PM Length

i don't know lotus domino... but my general experience with lotus (notes) databases were... well... well... uhm...

not sure lotus is free really. mysql is

	08-07-2004 17:33									#17
	Lose 30 kilos (of popups)

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 )

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

	08-07-2004 19:14									#18
	Remove this text

Ha . 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 .

	08-07-2004 20:00									#19
	Support Apolyton, buy Alpha Centauri

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........!

	08-07-2004 22:16									#20
	Support Apolyton, buy Alpha Centauri

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.

	08-07-2004 23:02									#21
	Get a bigger avatar today!

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.

quote: 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.

	08-07-2004 23:44									#22
	Got spare money?

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 .

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