mysql challenge - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

mysql challenge

mysql challenge# Database - 数据库

b*e2000-05-15 07:05

1 楼

let's say i have a task..
in a table that has 1 million rows, find a row
(search by primary key) and then go back say
100000 rows.. give me that row
how long does it take on mysql? how long on oracle,
ms sql or sybase :)
oh yeah.. mysql is faaaaaaaaaaaaaaaaaaaaaaaaaaast

n*e2000-05-15 07:05

2 楼

Really faster then Oracle,etc?
What do you mean by 'row back'?

【在 b****e 的大作中提到】

: let's say i have a task..
: in a table that has 1 million rows, find a row
: (search by primary key) and then go back say
: 100000 rows.. give me that row
: how long does it take on mysql? how long on oracle,
: ms sql or sybase :)
: oh yeah.. mysql is faaaaaaaaaaaaaaaaaaaaaaaaaaast

b*e2000-05-15 07:05

3 楼

sorry.. i meant "go back" :( typo..
and if you didn't notice.. i was being
sarcastic when i said fast :)

【在 n******e 的大作中提到】

: Really faster then Oracle,etc?
: What do you mean by 'row back'?

ug2000-05-15 07:05

4 楼

What is the SQL for this task? Just for curiosity.

【在 b****e 的大作中提到】

a*a2000-05-15 07:05

5 楼

find a row among 1M rows. that's SQL, isnt it?
to rollback is not SQL but it's an important metric for a
DBMS

【在 ug 的大作中提到】

: What is the SQL for this task? Just for curiosity.

b*e2000-05-15 07:05

6 楼

i meant go back.. not rollback :(

【在 a*****a 的大作中提到】

: find a row among 1M rows. that's SQL, isnt it?
: to rollback is not SQL but it's an important metric for a
: DBMS

p*v2000-05-15 07:05

7 楼

You mean the buffering cache stuff in Oracle making it faster, hehehe... I dont know..:)
But I do think Mysql is pretty cool, the more you use, the more you find out.
Oracle has too many fancy junky which is basically useless, and they charge like
a hell..:)

【在 b****e 的大作中提到】

B*n2000-05-15 07:05

8 楼

MySQL and Oracle have pros and cons in different aspects.
MySQL is cheap and fast and easy to setup if you only use it
in a
small shop;
on the other hand on one doing mission-critical will be
foolish
enough to choose MySQL over Oracle.
i guess it's all comes down to know your needs, and know the
facts before you post :)

【在 p**v 的大作中提到】

:
: You mean the buffering cache stuff in Oracle making it faster, hehehe... I dont know..:)
: But I do think Mysql is pretty cool, the more you use, the more you find out.
: Oracle has too many fancy junky which is basically useless, and they charge like
: a hell..:)

ug2000-05-15 07:05

9 楼

I still don't understand. I am barely new to DB, only learned some stuff
from school, haven't real experience yet.
What do you mean by go back? And how do you instruct the DBMS to do that?
And what is the file orgnization of the table?
Is there any indexes on the table? and what kind of index?
How large is the buffer bool in each DBMS you test?
What is the average size of your row?
Do you test the query alone OR together with other query running concurrently?
Again, the question are for my curi

【在 a*****a 的大作中提到】

: find a row among 1M rows. that's SQL, isnt it?
: to rollback is not SQL but it's an important metric for a
: DBMS

p*v2000-05-15 07:05

10 楼

I was talking about speed, sure, overall Oracle is a better database, but how abut
capability vs price?(which mysql is infinity..:) Anyway, dont wanna offend O fans
here, after all, we all living on it.

【在 B*****n 的大作中提到】

: MySQL and Oracle have pros and cons in different aspects.
: MySQL is cheap and fast and easy to setup if you only use it
: in a
: small shop;
: on the other hand on one doing mission-critical will be
: foolish
: enough to choose MySQL over Oracle.
: i guess it's all comes down to know your needs, and know the
: facts before you post :)