Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Benchmarks


Benchmarks

Author
Message
bytehd
bytehd
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 59
Anyone have the stones to publish some benchmarks on these:
I mean REAL marks, NOT TPC-D-W- 100,000 user fantasy benches
---------------------
DB/2
Oracle-pick-a-version
MS SQL 2000- forget 7
MySql 3/4
Pervasive 7+
Foxpro 6/7/8 (thats right VFP is faster than Oracle 8i)
Access 2000+ - [mudslow]
CACHE
TeraData
Sybase ASE 12+
Sybase ASA 8

Thanks User Community
--------------------------------------

PC User from Elbonia comes to America:

"We are excited to come to uhmereeka!!"

__Really, why?

"We want to check out your uhmericun databases"

__Really, why?

"All we have is Open Source in Elbonia"

__Yes, we know. Im Sorry. Can we buy you an economy?

"We are elbonians and need your uhmereekan no-how"

__Well, how can we help?

"Can you tell me which vendoors database is the queekest?"

__UM, no, I cant really

"Why is dat?" (DDS-DAT?$%#)

___Because, actually, we can. But Im not supposed to....

"To what?"

__Well, im not supposed to admit that we do run 10 different OSes and __15 different databases in the I.T. department.
__That was supposedly the "curse of the '80s"

"Does that mean you ahmereekans dont know?"

__ Umm, uh, let me check with our lawyers about that.

"Lawyurs? I thought you were the I.T. guys"

__Really, why?



Site Owners
Site Owners
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10091 Visits: 1
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Digital39
Digital39
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1
hey bytehd, I did a benchmark earlier this month for one of the microsoft newsgroups. While it is not the best benchmark for a number of reasons mainly because of the very simple query, it gives you an idea of the differences of mysql and mssql. You can also find a MSSQL,MySQL,Oracle,Access benchmark http://www.sloppycode.net/benchmark/

Here is my benchmark

System:
P4 1.4ghz
128 RAM
SQL Server Ent. Eval.
MySQL v3.23.55

Database: Test
Table: Temp
Column: Col001 char(32) NOT NULL
No Indexes on either

DB Size (MSSQL)
4 Million records
334 MB after shrink

DB Size (MySQL)
8 million records
251 MB

MySQL
Query = SELECT COUNT(*) FROM TEMP
Command Line = 0.18 sec
ODBC Connection w/ASP = 3.0 sec
*Note* The 3 seconds was only the first query, after that the time was less
than a second

MS SQL
Query = SELECT COUNT(*) FROM TEMP
Query Analyzer = 10.0 sec (after 2 previous queries, first was 13 sec)
OLEDB Connection w/ASP = 13.0 sec


My Benchmark, unfortunately I did not record the time it took to load the
records into the database, but the load time for sql server was about 4
times slower. The records were created by using a for loop to make a list
of 100,000 numbers hashed with the md5 algorithm, so 100,000 32 character
strings. They were then loaded into each database server from the text file
by using the importing features that come with each database server. Each
query was run 3 times to eliminate some lag. When run in asp time difference
was determined only by using Now() not by using a timer function so time is
only expressed in whole seconds for asp, not 10ths or 100ths of a second.
Both database servers were fresh installs installed just to test this so no
tuning was done to either which also makes the times a little slower.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search