• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Optimizing MySQL Database structure for big big data

#3
[eluser]Sean Murphy[/eluser]
I agree with Crafter, creating a database for each entry doesn't sound like it would scale well even for a very small site. Not, a good idea.

Are you thinking of sharding, or table partitioning? These techniques are sometimes used to increase performance on incredibly large sites (YouTube, Digg, etc.), but I doubt you'd need to worry about it.

I think you'd have better success optimizing your queries and storage engines. Also, if you're constantly joining on the same tables, you might try de-normalizing your schema where you can.

Hope that helps!


Messages In This Thread
Optimizing MySQL Database structure for big big data - by El Forum - 02-13-2008, 04:07 AM
Optimizing MySQL Database structure for big big data - by El Forum - 02-13-2008, 02:36 PM
Optimizing MySQL Database structure for big big data - by El Forum - 02-13-2008, 04:57 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.