MS-SQL 2000

If it gets enough votes I'll try to rewrite queries in vBulletin to work with Microsoft SQL 2000. If anyone is interested, feel free to post comments and suggestions.

I beg to differ Wayne -- it's been shown that Sybase ASE is both faster and cheaper than Oracle on both large-scale and mainstream (e.g Sun 64-way E10000s, Compaq 4-way ES40's, etc.).

(leaked) Benchmarks have somewhat damaged MS SQL's reputation for speed, some even suggesting that SQL Server 7.0 is FASTER than a comparably equipped SQL 2000 set-up.

so going up with sybase ?
hum....i gone give it a try......but have to get it before and learn it too...

Originally posted by Preacher
i have read your post on Why you don't like mysql...quite complete.....but now for Vbulletin what could be the better and the fastess db we could use do not look the price....event if its 10 000 $....

Bar none it's MySQL for small scale systems. You can't beat the performance if you have relatively few users on it. Of course, the need for a more robust system in the first place is BECAUSE you have heavier demands so we'll assume something larger than what MySQL can handle.

From what I've heard, PostGRES is quite capable at handling loads that MySQL would die at -- AND it supports cool things like stored procedures, triggers, et. al of that junk that I said before. I'd give that a try first because it's free (as in source).

Barring that -- I'd take a look at the commercial DBs out there. When you start getting into the likes of DB2, Oracle, and Sybase you're talking WORLDS more complexity than MySQL or PostGRES. If you're a non-technical person you're most certainly going to need someone (preferably a DBA) to set it up for you and to from time to time look in on it and make sure everything is all good.

Microsoft SQL Server offers much of the fine-tuning that you can get from Oracle / Sybase / DB2 (henceforth known as 'the big boys' ) but it shields you from that complexity via a nice windows interface. Because of this, it's MUCH easier to configure / maintain for a non-DBA (scheduling backups, query tuning, etc. is a breeze!). Unfortunately, the performance of SQL server is, as you might expect, much less than the big boys. Oracle claims that they can take your application running on SQL Server and give you a 2 or 3 x performance increase from switching to Oracle. If not they'll pay you $1,000,000! (or maybe it's 2 now, not sure).

So really the determining factor can't be pinpointed to just one aspect of RDBMS design -- you have to evaluate your situation, your hardware, scalibility, integration to other packages, etc.

That said -- GO SYBASE!

P.S. one of my threads talks about where to get Sybase -- ASE 11.0.0.3 is 100% free for any use that you want. ASE 11.9.2 is free for preproduction use and testing only, if you want to use it in production then you gotta pony up the bucks.

(This isn't actually directed at Matt as he obviously knows what I'm going to say. It's more for beginning PHP developers)

Originally posted by mrogish
The abstraction class in vB is nice, but there are no easy ways to do a 1-for-1 swap of db.php and expect it to work.

Despite this, it doesn't mean you shouldn't use an abstraction class. vB's class handles multiple types of connections, with and without passwords. Automatic error handling on every query and emails you with the error. And automatic memory management (when calling query_first).

Trying to do that without using a function would probably double your code size. And you know how much duplicate code you'd have, right?

Originally posted by Ed Sullivan
Despite this, it doesn't mean you shouldn't use an abstraction class. vB's class handles multiple types of connections, with and without passwords. Automatic error handling on every query and emails you with the error. And automatic memory management (when calling query_first).

Trying to do that without using a function would probably double your code size. And you know how much duplicate code you'd have, right?

Of course! I use a DB class for my apps as well -- it's recommended by most design sites that I have seen on the web for Mike's reasons (and more!) -- so beginning programmers listen up -- Mike speaketh the truth! Listen to his sage advice!

From a portability standpoint, however, it does you no good because you end up re-writing each query anyway.

However, if the world was a perfect place and everyone was ANSI compliant it WOULD be a great solution to the portability problem. Just include a different db.php and voila -- instant port to a different RDBMS!!

MS Access owns j00 all!

I thought the thread could use a little humor!

Originally posted by PFunk
MS Access owns j00 all!

I thought the thread could use a little humor!

LOL. Access does indeed 0wn us all!

I would wery muct like to use a MS SQL version..

Organizer

Originally posted by mrogish
I beg to differ Wayne -- it's been shown that Sybase ASE is both faster and cheaper than Oracle on both large-scale and mainstream (e.g Sun 64-way E10000s, Compaq 4-way ES40's, etc.).

I have only worked with MS-SQL Server 6.5 extensively.

Also Our application performs better, more robustly and with fewer resources (average load on the Server - 0.1 with 1000 users) under Oracle 8.1.6 than it did under Sybase ASE 11.5 (average load - 48.0) on similar hardware.

Originally posted by wluke
I have only worked with MS-SQL Server 6.5 extensively.

Also Our application performs better, more robustly and with fewer resources (average load on the Server - 0.1 with 1000 users) under Oracle 8.1.6 than it did under Sybase ASE 11.5 (average load - 48.0) on similar hardware.

SQL 6.5 was kind of a bad build, almost like Sybase system 10.

What kind of an application do / did you run on ASE 11.5? Those loads are pretty crazy and *something* would have to be wrong. I'm not sure how 11.5 was configured but it seems pretty abnormal.

We've seen some pretty dramatic cache hits (150,000 or more a second) on Sybase ASE 11.9.2 on the Intel platform -- we've committed the move to Solaris and ASE 12.0, I can't wait till the servers arrive!!

But to make SQL Server 7/2000 you'd need a significant amount of cash to get the licences (NT/2000 Server as well) -- check out ASE 11.0.0.3 -- 100% free for any use!