SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: Performance

  1. #1
    SitePoint Enthusiast Patrick Lucas's Avatar
    Join Date
    Dec 2001
    Location
    Ohio
    Posts
    77
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Performance

    Where can I find out about performance for mySQL stuff? I just have general questions about how to organize my tables and such. Like, is it better to have one big table with all your news? Or separate tables by category? Will a search be faster by searching one big table, or four separate tables?

    Thanks
    Patrick Lucas

  2. #2
    Are you ready for BSD? Marshall's Avatar
    Join Date
    Dec 2001
    Posts
    373
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Testing is the only way that you're going to find an answer to most of these questions. The results depend heavily on your own unique usage situation. Discover which data views or modifications will be requested most often and optimize your database design to speed access for those queries. Data retrieval speeds can be greatly improved by creating indexes for the keys most commonly searched. For more information on creating indexes in MySQL see this tutorial.

    - Marshall

  3. #3
    SitePoint Enthusiast xev's Avatar
    Join Date
    Jan 2002
    Location
    USA
    Posts
    29
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    As long as the columns will be the same for each category, it would be best to just put it all in one table. It is much more difficult (and slower) to do a search on four seperate tables and combine the results than to just search a single table. It will also be a lot easier to maintain if you use only one table.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •