PHP & SQL: need help in a directory script

[thermodynamics]

I am creating a directory wiht more than 100,000 categories will it be any problem for my database

Tell me about the quantity of data a database can hold?

I am expecting lot of visitors

Whether I can create separate databases for each of 10,000 cateogories

 

[krakjoe]

there's no problem with storing that much data in a database....
it might be easier for you though, if you have more than one database by splitting the categories into major and minor sections ....

 

[Tree]

Having more databases is more strenuous on the server than just having one big one. Keep in mind MySQL's limit is 4GB. That's about 5 million rows. If you need more than that, consider moving to Oracle or even MSSQL.

 

[krakjoe]

not neccesarily, if compiled with multithreading, most are, then you can mount more than one connection and save time reading disks, there wouldn't be a lot of difference between having one huge and 5 reasonable databases...