Databases
StackOverflow2013
Postsdbo
POUser actions like social networks facebook,myspace, all big ones
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUser actions like social networks facebook,myspace, all big ones
    primarykey
    data
    text
    <p>I am working on a social network type site in PHP, I have done this once before and the site outgrew my coding ability to keep up, this was a couple years back and now I am wanting to tackle this project again.</p> <p>Basicly on my network there is a friend_friend mysql table that keeps track of who is who's friend, for every confirmed friend, there are 2 entries into the DB here is that table:</p> <pre><code> CREATE TABLE IF NOT EXISTS `friend_friend` ( `autoid` int(11) NOT NULL AUTO_INCREMENT, `userid` int(10) DEFAULT NULL, `friendid` int(10) DEFAULT NULL, `status` enum('1','0','3') NOT NULL DEFAULT '0', `submit_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `alert_message` enum('yes','no') NOT NULL DEFAULT 'yes', PRIMARY KEY (`autoid`), KEY `userid` (`userid`), KEY `friendid` (`friendid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1657259 ; </code></pre> <p>I then have a user table with all users info called friend_reg_user</p> <p>Then a table for bulletins that users post, the object is to only show bulletins from users who you are friends with. Here is bulletins table</p> <pre><code>CREATE TABLE IF NOT EXISTS `friend_bulletin` ( `auto_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(10) NOT NULL DEFAULT '0', `bulletin` text NOT NULL, `subject` varchar(255) NOT NULL DEFAULT '', `color` varchar(6) NOT NULL DEFAULT '000000', `submit_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `status` enum('Active','In Active') NOT NULL DEFAULT 'Active', `spam` enum('0','1') NOT NULL DEFAULT '1', PRIMARY KEY (`auto_id`), KEY `user_id` (`user_id`), KEY `submit_date` (`submit_date`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=455144 ; </code></pre> <p>Ok so to do this I would either run a query on the friend_friend table to get all friends of a user and add them to a string like this 1,2,3,4,5,6 those would be friend ID numbers and then select from bulletin table where bulletin author ID is in my friend ID list</p> <p>The second method is to use JOINS to get all this data at once.</p> <p>My quest now finally, once the site gets very large, when there are millions of friends records and bulletins in the DB this all slows down, what are my options to speed things up? Is there a better way to do this? Also I am planning on changing bulletins to include more then just bulletins but do more of user actions like the big sites do now so it will show status updates and blogs and bulletins and all</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJon Seigel
    1. USJasonDavis
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUser actions like social networks facebook,myspace, all big ones
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POUser actions like social networks facebook,myspace, all big ones
      1. USDJ.
      1. VTFavorite
    3. VO
      singulars
      1. POUser actions like social networks facebook,myspace, all big ones
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload