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

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

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

Posted by: aftab khan
Date: February 21, 2009 11:59AM

i suggest you to use table partioning (available in 5.1)at present you are finding it hard to load 350m rows, after that your reports will run slow. Check whether you can partition the data by date, list,range etc..

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!)

15533

Reid Wilson

February 09, 2009 04:12PM

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

5372

Rick James

February 10, 2009 12:28AM

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

4264

lau ch

February 10, 2009 02:13AM

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

3918

Rick James

February 11, 2009 01:46AM

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

3403

Reid Wilson

February 11, 2009 12:19PM

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

3386

Rick James

February 11, 2009 10:21PM

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

3465

aftab khan

February 21, 2009 11:59AM

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

3118

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.