Re: Can MySql handle Large data?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Just my two cents, but I doubt if Yahoo uses the same implementation of MySQL as we do. They probably have a tweaked version of it that fits their needs better than the free public version. Bare in mind too that MySQL *is* a commercial company, even more so now they've been acquired by Sun.

That being said: The largest table I've had so far has 1 million+ records in it. No problems with performance, but much depends on how you define indexes and how you write your queries obviously. I think design is more important than size!

Yves

----- Original Message ----- From: "Abah Joseph" <joefazee@xxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Sent: Monday, November 17, 2008 11:15 AM
Subject:  Can MySql handle Large data?


I want to quickly ask if MySql can handle large data like 10 – 20 million
rows in one database (e.g member table)

The question came to my mind is, How did large website like Yahoo handle
such data? Sure. Yahoo users may be more than 20 millions users or so.


Users will have -permission table
                     -profile table
                     -page table  and so on, so query will be perform on 2
or three tables same time, i`m trying to check the speed, performance and
risk .

I need your advice on how to handle such data and the best structure to use.



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux