Support NeoGAF

[Matlock]

What the heck is behind that? Bueller? Bueller?

 

[Hitokage]

Each page taps into the matrix, multiple times!

 

[Matlock]

Each page taps into the matrix, multiple times!

Ya, but what are the six queries for a normal thread page? I'm curious.

 

[impirius]

Getting rid of tags saved 57 queries!

 

[demi]

Ya, but what are the six queries for a normal thread page? I'm curious.

Is the thread Matlock's?
Is Matlock's topic worthwhile?
How many times has Matlock posted?
How many times has Matlock replied to himself?
How many sarcastic replies has Matlock received?


the sixth query was removed due to bandwidth issues

 

[Matlock]

Is the thread Matlock's?

Yes

Is Matlock's topic worthwhile?

Yes

How many times has Matlock posted?

Too fucking many

How many times has Matlock replied to himself?

None, in the history of gaf

How many sarcastic replies has Matlock received?

2

the sixth query was removed due to bandwidth issues

tag database

 

[Jonnyram]

Getting rid of tags saved 57 queries!

How? I still see 5+ custom tags in threads that only took 6 queries.

 

[SyNapSe]

Sweet Jesus, I hope Matlock dies. I LIKE NACHOS

 

[impirius]

How? I still see 5+ custom tags in threads that only took 6 queries.

Neodyminium precache tagcasting

 

[NLB2]

Awesome thread. +1 custom tag/

 

[Blimblim]

What the heck is behind that? Bueller? Bueller?

On the forum I coded there is one query for the session itself, one query for getting the page content (topic list or topic content), one for updating the session and one for updating the list of topics seen/unseen. Depending on the database structure of vbulletin there could be more update/insert queries, but that should be it.

 

[ToxicAdam]

On the forum I coded there is one query for the session itself, one query for getting the page content (topic list or topic content), one for updating the session and one for updating the list of topics seen/unseen. Depending on the database structure of vbulletin there could be more update/insert queries, but that should be it.

The real answers are never as fun as the ones in my head.


Quit destroying my make-believe world, with all of your realityspeak!