Can MySQL Handle 1,000,000 Items?

[erisco]

This may sound crazy, but I was wondering if MySQL could handle 1,000,000 items efficiently. I will need to store 1 million URL's and then two or three extra pieces of information for each one (columns right?).

The URLs will link to 1 million images stored in a folder (is that possible?) so that a viewer can select a range of images to view (say 50,000 to 50,010) and then they will be displayed.

The whole project will take roughly 60GB of storage (yikes!) but if this is plausible (without a 5 hour loading time) it will be for a good cause.

Thanks so much for your help!

[-i-dont-know-]

http://www.eweek.com/article2/0,3959,293,00.asp
This might help.

[erisco]

Could I just get a solid answer? hehe

I read the article but it sort of went over my head. It was saying something about 200,000 items? Could it run 1,000,000 though?

[Horus_Kol]

http://www.linuxplanet.com/linuxplanet/print/6034/

http://software.newsforge.com/software/04/12/27/1243207.shtml

I shouldn't think that the number of records you're planning is going to be an issue - I know of some high level solutions where MySQL has been implemented (ticket booking system for Lufthansa, for example).

[erisco]

Thanks. I will give this thing a shot!

[Horus_Kol]

forgot to add - the amount of data is not usually the problem... it's how data is structured and indexed...

[afterburn]

thank you Horus most developers fail to realize that you can structure data almost anyway but not always the way it is best used in a db.