Sybase ASE 12.5 Benchmarks released...

[MattR]

http://www.tpc.org/tpcc/results/tpcc_perf_results.asp?resulttype=noncluster&version=5

It's not a chart-topper but take a look at the price/tpmC and then the specs of the box (16 CPUs).

In the 16 way category, Sybase performs 96% faster for a cost of 3.2 times less than Oracle.

If you compare a 32 way number (barring that one with 9i showing some 230K number) Sybase still performs equally good (Sybase 140K vs. Oracle 155K) for 3.2 times less price than Oracle.

[eva2000]

:D

[Hooper]

Hi Matt,

I know you prefer sybase over mysql. I have read your post at sitepoint and understand a bit of what you are saying. How difficult is it to port vb to sybase? I mean, without the complicated terms that I know you could easily produce for an answer. Is it easy? Moderately easy? moderatley hard?


Or should the person that attempt porting to Sybase get a degree in programming first?


Thanks Matt.

[MattR]

Well, as has been said before -- anyone who understands T-SQL could 'directly' port the app over. That is to say, fix the queries so that everything 'works' and doesn't give an error.

However, to *really* port it -- to make it *worth* your time you need to know a couple things:
1) your RDBMS -- inside and out. All the nuances, the tips, tricks, etc.
2) your data -- MS SQL and Sybase have 'clustered' indexes, Oracle has a 'ordered' table and what not. Depending on how you set these indexes up it can be an order of magnitide faster for *certain* queries.
3) Relational theory -- don't get me wrong, vB is a great product. From a strict design standpoint, however, there is considerable room for improvement.

In any rate, to 'really' port it (triggers, stored procs, etc.) it takes a *long* time.

[Hooper]

Just curious as to the knowledge needed. Beyond my knowledge by a long shot.


I haven't had any problems with mySQL. I think its great. I did notice the amount of traffic your site has generated over the last year though and the numbers of new members you have gained. Quite impressive. And I would assume that this type of network activity would profit from the use of sybase.

I just find it interesting is all. You are one of the vBulletin members that I find to be quite uniqe. :D

Thanks for sharing.