36 Million records!

[Armitage]

I started dumping 3 DvDs worth of data into my MySQL db late saturday night. I just passed 36 million records (started with 8 million), and probably have about 4 days left to go. I'm still getting good query performance Very simple queries, on indexed fields of course.

And yes, it gets dumped, and backed up to tape every night!

 

[Bulldog13]

data for what ?

 

[Armitage]

Satellite element sets

 

[Davegod]

:cookie;

 

[Noid]

Cookie

 

[Armitage]

Hah ... 37 million!
Thanks for the cookies

 

[Looney]

You'll probably get a much more receptive response at /. than here (alot more geeks over there).

 

[Armitage]

Originally posted by: Hardcore
You'll probably get a much more receptive response at /. than here (alot more geeks over there).

Meh ... this might be a /. worthy story when the service goes live. But true geeks probably aren't all that impressed with a mere 37 million records. That's what I was told by a "true geek" :roll: over lunch today.

Ah well. I'm excited. Maybe I'm just easily amused

 

[everman]

Originally posted by: Armitage

Originally posted by: Hardcore
You'll probably get a much more receptive response at /. than here (alot more geeks over there).

Meh ... this might be a /. worthy story when the service goes live. But true geeks probably aren't all that impressed with a mere 37 million records. That's what I was told by a "true geek" :roll: over lunch today.

Ah well. I'm excited. Maybe I'm just easily amused

What kind of service...involving some kind of satellite records?

 

[BFG10K]

I wonder how much faster SQL Server would be.

 

[Armitage]

Originally posted by: everman

Originally posted by: Armitage

Originally posted by: Hardcore
You'll probably get a much more receptive response at /. than here (alot more geeks over there).

Meh ... this might be a /. worthy story when the service goes live. But true geeks probably aren't all that impressed with a mere 37 million records. That's what I was told by a "true geek" :roll: over lunch today.

Ah well. I'm excited. Maybe I'm just easily amused

What kind of service...involving some kind of satellite records?

Yea ... can't go into it to much at the moment. Hopefully in a few weeks.

edit ... 38 Million ... the last few years don't have as much unique data as I had expected.

 

[Armitage]

Originally posted by: BFG10K
I wonder how much faster SQL Server would be.

:roll:

 

[Armitage]

Well, it finished up just shy of 39 million records (38995722 currently). Turned out to be alot of duplicate data in the last few years.
The DB receives several hundred new records a day, so it's still growing.

 

[awal]

Originally posted by: BFG10K
I wonder how much faster SQL Server would be.

what he said

 

[Bulldog13]

Wonder how much faster Access would be ?

 

[Sunner]

Originally posted by: adrianwalters

Originally posted by: BFG10K
I wonder how much faster SQL Server would be.

what he said

I wonder how much faster a 64-way POWER5 running AIX and DB2 8.1 would be.

 

[Modeps]

Originally posted by: Bulldog13
Wonder how much faster Access would be ?

A truly stupid comment.

 

[BFG10K]

http://forums.anandtech.com/i/expressions/anim_roller.gif

Are you under the impression that MySQL is some kind of fantastic database management system or something?