SQL for Wayne

[t951]

Does anybody have an extra, legitimate SQL license to give Wayne?
Pelican is getting slower and slower, to the point of being difficult to use.

He mentioned that he was having an issue with the MySQL and that the Microsoft version could work better.

I know he takes his time testing, (remember how long he was testing that posting button, like 3years! ) but I am thinking that if the Pelicans can flock together we can help him out, get him the software and maybe even roll the db over!

Maybe we could even help him update the vB software as well....


Am I dreaming? Could this be a pelican team thing?


t.

[Bill Douglas]

Microsoft SQL is slow.

[t951]

That may be true, but something needs to be upgraded..

[legion]

This BBS should be on DB2 for zOS.

[id10t]

there are lots of free (and Free) databases out there... since the forum is written in php, changing from mysql to postgres or similar should be easy..

Of course, the mysql would probably run better if it weren't on Windows... (one of the bsds or linux come to mind...)

[HardDrive]

Originally posted by Bill Douglas
Microsoft SQL is slow.

Please provide testing information to back this up.

[t951]

I am fairly sure a MS SQL db could handle the load here fairly easily...

The php stuff, I don't know.

I was thinking of the vast resources that are on here and with the good sense of community we seem to have we could tweak this.

Right now its Pelican Parts. Let's make it Pelican Turbo Parts...

We can poll for the most desired features, etc....

[Joeaksa]

Originally posted by t951
I am fairly sure a MS SQL db could handle the load here fairly easily...

The php stuff, I don't know.

I was thinking of the vast resources that are on here and with the good sense of community we seem to have we could tweak this.

Right now its Pelican Parts. Let's make it Pelican Turbo Parts...

We can poll for the most desired features, etc....

I run several BBS's using PHP and they work well. That said very few BBS's have the number of posts and users that PP does. As well PHP are well known by the hackers. I have about 20 a day that are registering to post and are deleted. Its a pain but something we have to put up with.

[Bill Douglas]

Whoo hoo, Harddrive is from Seattle. I'm terribly sorry to say anything against the glorious Microsoft. I was, in my naivety, going to say Oracle SQL is a good product.

[JasonDTM]

When you do goto vb3 and still need some help, I'm pretty good friends with the guy that handles the SQL aspect of vbulletin.

[HardDrive]

Originally posted by Bill Douglas
Whoo hoo, Harddrive is from Seattle. I'm terribly sorry to say anything against the glorious Microsoft. I was, in my naivety, going to say Oracle SQL is a good product.

I'm still waiting on those tests

Oracle is indeed a good product.

[jeffgrant]

FYI, all this talk of "this is better than this" is very subjective.

I can show you test-cases that will make any database look better than any other database.

I own a company that does high-end database design and distributed performance tuning (largest on-line banking systems in the US and Canada, government, IRS, etc), and it's all about the right tool for the right job, and the proper implementation with the right tool.

If the code is ****, it doesn't matter what DB you're using.

But yes, certain features are better implemented in some databases than others.

It's a matter of figuring out what you need and picking the right tool.

MySQL has it's good points, and it's bad points. It's probably the fastest read-only DB on the planet, other than a custom-built DB, but it suffers in other areas.


Of course, I'm a huge Oracle fanboy, but that's a whole other topic.

[dhoward]

Originally posted by legion
This BBS should be on DB2 for zOS.

+1

[KFC911]

Originally posted by legion
This BBS should be on DB2 for zOS.

Surely you jest... Wayne provides us with a free sandbox to play in, and you want him to pay for "golden sand" too? I'm a mainframe bigot from way back, but ZOS is certainly not a "cost effective" solution for this BBS...DB2 for serving up "grid girls"?

ps: Just because your toobox contains DB2 (a "hammer"), doesn't mean this BBS is a "nail"

[dhoward]

No, really serious....

[legion]

Surely you knew I was kidding.

zOS is more like using a pile driver on a push-pin.

Maybe a move up to a mid-grade server?

(Do they still make the AS400?)

[KFC911]

Originally posted by legion
Surely you knew I was kidding....

I don't think Dan is . I have no idea about AS/400s (I doubt it), but they are still around as I still support a few (networking wise) that are in Europe.

[dhoward]

AS400 is now I-Series.
Same OS400 / Same DB400
Work with Active Jobs?

[t951]

open systems= cheap
they are great for what this bbs needs.

wayne, do you have a turbo button on the server you can push. (remember how the 486's had those?!)

hey, maybe its time to go water cooled? porsche did it, maybe the bbs should to.

[jriera]

Have to disagree on that one, MySQL is (at least) as good as MS SQL, specially for large volume transactions and storage, the algorithms behind the reindex are far superior.

What version of MySQL have you installed? if a db is corrupted does not matter if is MySQL od DB2 on zOS .. first thing is to fix the corruption, think about using MySQL Cluster or to provide some kind of fault tolerance to the db (easily done at the OS level)

Originally posted by Wayne at Pelican Parts
MS SQL is a superior product to MySQL. That said, vB only works with MySQL. There are two elements to the problem, the server and the connection. The connection is now due to beupgraded the first week of August (finally). You have no idea how many times this has been messed up by our provider.

The MySQL issue may have to do with database corruption. I have set the tables to rebuild each night now at 2AM. We'll see if that works for the time being. I'm going to upgrade to vB3, but probably only after the connection is upgraded from 6MB to 10MB...

-Wayne