Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Actually, it is a very bad idea to stor the friend array in the session. What happens if some you add a new friend after the session variable is created? It does not get updated in the session.</p> <p>Since you will be checking the list of friends a lot of times on the same page, why not just query it out and store it in a local array that you can keep using on the same page.</p> <p>When the page finish executing, the array will be discarded.</p> <p>So basically, you will only query the list out once.</p> <p>A recommended implementation would be to follow the advise of "pst" in the above comment, and just query for every time you need to find the relationship first, as that is simple to implement. Later, when the speed of the query starts to become a issue, you can just change the internal of that method to cache the friend list in a local array when it is first called to speed things up. (exchange memory usage for processor usage).</p>
    singulars
    1. This table or related slice is empty.
    1. POIn a social network environment, what would be the easiest way to check for friendships globally?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USiWantSimpleLife
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIn a social network environment, what would be the easiest way to check for friendships globally?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks for the reply. Well, as it is now, I have a query that checks the `friendships` table for an existing, valid match between two users. If the number of rows found is not zero, then a friendship is determined. To use the local array method, I'd need to change my query to pull all valid friendship matches from the table, and then test against that. I realize now that the array idea is less efficient. However, it brought up a question I have. Does there come a point in which you can query the database too often, or does that not really matter?
      singulars
      1. PO
      1. USvertigoelectric
    2. COMy take on that is that database query is getting cheaper, cpu power is getting cheaper. Basically, the capabilities of computers are getting cheaper every day. So the first thing you should be concerned with is to do the right thing. Get it working with the correct logic first. Then see if it needs to be optimised. If it runs fast without any optimisation, then you have just saves a lot of time. If it runs show, at least your codes are easily understood by anyone, because there is no weird logic to attempt to speed up the codes. It will make the codes easier to maintain and to optimise.
      singulars
      1. PO
      1. USiWantSimpleLife
    3. COYou will most likely need to write the codes, then bench mark it against real live conditions, then you can decide if the number of queries are too much. But as a rule of thumb, I try to stop at 50 queries per PHP page.
      singulars
      1. PO
      1. USiWantSimpleLife
 

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