[eluser]Benjamin David[/eluser]
Hi,
I'm working on a project on which some database tables will be quickly subject to have millions of entries that will be often updated and even more often called. There will be a lot of JOIN between tables of millions entries, it's a real nightmare. The site will have around 700 000 page views a month.
I heard somewhere that instead of having, let's say a table like this :
Table_name : id_entry, name_entry, etc
Benchmark tests have revealed I could do somthing like creating a database for each entry and recreate the database structure.
This solution has been tested and works well but doesn't seem very scholar to me. Do you have interesting reading on this particular subject ? I've been Googling around but couldn't find anything serious or complete about this.
Thanks a lot