The New Home of World Records

Current

1,001,644,067 rows

Most Rows In A Single Database Table

magnify
Loading...
points
Follow Record Unfollow Record

Rate it:

Tags: computer, technology, database, row

COMMENT ON THIS RECORD

  • +1

All Comments for this Record Category

  • response to this attempt +1 Denis Dervisevic

    Denis Dervisevic

    @Dan and James

    As james has proven it can be done, however i did it the stupid way by just looping a PHP script to my mediatemple server, what's the point in cheating really? And i don't even have the record any more. Not sure if mediatemple compressed the db or anything else or perhaps the setup differs, I'm not sure but it showed 6.5GB in PHPmyadmin.

  • +1 Dan Rollman

    Dan Rollman

    Denis, comments on James' point?

  • +1 James Coleman

    James Coleman

    No way that could be possible, mine was 80GB+ big, not 6.5GB. I had my computer say that I'm running out of disk space and all... All you did was right click->Inspect Element and edited. And here is proof you can do that. http://mrgeckosmedia.net/grab/1121db40a297fc613c139a826b40a4f1.PNG

  • 0

    I had a backup of 1 billion ready to go, but 10 billion, hats off, awesome.

  • +1 Mark Rogers

    Mark Rogers

    Just for fun, I inserted 6,203,538,627 rows into a single table using SQL Server 2005. I could have easily added more if I had a bigger hard drive.

  • 0

    Heya coreyh, this is a MySQL server(5.1.26-rc) hosted at mediatemple.net. This perticular database is only used for this as an experiment. It's only populated by 1's.

  • +1 Corey Henderson

    Corey Henderson

    I'd like to know more about this. What type of database is this? Is this being used in production or was this just an experiment?

Under review comments