MySQL :: Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

New Topic

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

Posted by: Reid Wilson
Date: February 11, 2009 12:19PM

Thanks for your advice. An addition to my "is this as fast as it can get?" -- a simpler example:

To the 350+ million row table, I did a simple "alter table add column column_name varchar(255)"

I started it over 14 hours ago. It is still running.

Does that sound right?

Thanks -- much! -- for any insight you can provide. I'm just not sure if what we're trying to do is realistic within our time frame.

Reid

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

350+ million rows -- is this as fast as it can get? (too slow at the moment!)

15228

Reid Wilson

February 09, 2009 04:12PM

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

5259

Rick James

February 10, 2009 12:28AM

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

4127

lau ch

February 10, 2009 02:13AM

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

3775

Rick James

February 11, 2009 01:46AM

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

3281

Reid Wilson

February 11, 2009 12:19PM

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

3283

Rick James

February 11, 2009 10:21PM

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

3358

aftab khan

February 21, 2009 11:59AM

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

3006

Osman SARI

February 23, 2009 01:18AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.