Hoops

Start a new topic

Choose the category that best suits your topic.

Check this if your topic contains a game spoiler (e.g., an NBA game that might be televised later).

Check this if your topic is spam.

You must read the Terms of Use. Please do not post offensive material.
Learn how to embed YouTube videos or tweets

array(2) { [0]=> string(815) " select r.*, rc.info, t.title as threadtitle, u.username as username, u.anonymous as useranonymous, `f`.`value` AS `flairvalue`, `ft`.`name` AS `flairname`, `ft`.`colour` AS `flaircolour`, `ft`.`icon` AS `flairicon` from reply as r join thread as t on t.id = r.threadid join replycontent as rc on rc.replyid = r.id join user as u on u.id = r.userid left join `flair` `f` on `f`.`userid` = `u`.`id` and `f`.`categoryid` = `t`.`categoryid` left join `flairoption` `ft` on `ft`.`id` = `f`.`flairoptionid` where r.businessid = :businessId and r.threadid = :threadId group by r.id order by r.utcdated desc limit 0,50 " [1]=> array(2) { ["businessId"]=> int(1) ["threadId"]=> int(17952) } }

Anonymous

Years ago

Super Mario- How did they miss him?

Yeah, fan of the fern.

Whats the deal with Phi right now by the way?

Reply #210616 Report this topic

Anonymous

Years ago

Maybe.

Who's playing today?

Reply #210606 Report this topic

Anonymous

Years ago

Just a quick update. I've modified the query that builds the main index and it should now be roughly 7 times its original speed.

The time it takes to load that front page is composed of a few elements -- you querying the server, the server querying the database, the server sending the information back to you, and your browser rendering it -- and that second item is where the improvement has been made. You'll still get the usual lag of internet traffic and rendering a page full of laid-out text, but roughly 7-10 seconds have been shaved off.

The other change worth mentioning are the index listing options. You'll see them at the top of the index where it says:

Topics: | | |

Hopefully someone will find these useful. Recent is the default you're used to. Latest Action (which I think most people will like) shows topics with replies, ordered by their most recent replies; a lot of internet forums are ordered like this, but it means that new topics can quickly disappear from the front of the site. Most Reads and Most Replies are self-explanatory. Most Reads is weighted against older topics as the read-count wasn't introduced until a few months ago.

Oh, and for a bit of fun, below the Reply Leaderboard, I've added the Hoops SA Starting Five which shows the top five posters from the last seven days. Should give us a fair indication of who's slacked off at work, on holiday, etc...

There should be more changes over the coming months.

Reply #832105 Report this topic

Start a new topic

Super Mario- How did they miss him?

Reply to this topic

Recent Posts