Timeline for Query: user can see all posts by him and his friends

14 events

when toggle format	what		by	license	comment
May 2, 2015 at 19:21	history	edited	Jamal	CC BY-SA 3.0	deleted 2356 characters in body
May 2, 2015 at 19:18	history	edited	Caridorc	CC BY-SA 3.0	meaningful title
Jun 4, 2013 at 9:12	answer	added	Kickstart		timeline score: 1
May 8, 2013 at 14:32	vote	accept	Mercurial
May 8, 2013 at 14:09	history	edited	Mercurial	CC BY-SA 3.0	added
May 8, 2013 at 13:30	answer	added	GlenPeterson		timeline score: 3
May 7, 2013 at 16:07	comment	added	Mercurial		all the things you mentioned are well maintained in my database. I was worried about this long query. I thought this many operations and comparisions are slowing this down. Can you please take a look and confirm that it is well enough.
May 7, 2013 at 15:59	comment	added	Quentin Pradet		Not really. Denormalization, indexes, foreign keys, this is what you need. It could make the query simpler but will make other code more complex (eg. code that writes into the database).
May 7, 2013 at 15:52	comment	added	Mercurial		My ultimate goal is faster query. What i thought, lesser the number of operation/compare, lesser the time.
May 7, 2013 at 15:43	comment	added	Quentin Pradet		Do you want the code to be shorter or the query to execute faster?
May 7, 2013 at 10:23	history	edited	Mercurial	CC BY-SA 3.0	Added some details.
May 7, 2013 at 8:22	history	edited	Quentin Pradet	CC BY-SA 3.0	format query
May 7, 2013 at 6:24	review	First posts
May 7, 2013 at 7:00
May 7, 2013 at 6:06	history	asked	Mercurial	CC BY-SA 3.0