 Close Encounter?
#18179 posted by sock on 2010/03/05 00:08:14
I have not been in the UK for a long time (5+ yrs) and I was wondering does the UK crowd from this board ever meet up!?! Like arrange a time in london in a pub on a weekend and insult each other face to face in real life? :P
 Where Abouts In The UK Are You Sock?
#18180 posted by RickyT33 on 2010/03/05 10:31:48
Im in Cumbria, opposite corner of England to London. It would take be 6-7 hours to get to "a random London pub".
Come up here and we can go sheep-spotting :)
 Well...
#18181 posted by sock on 2010/03/05 10:53:57
If there is not much interest in a general get together I will travel around and just meet people individually. I am located near Guildford in Surrey at the moment. I do want to put a face to the text that is typed here, so yes RickT23, that does sounds cool :)
 Damn Typos
#18182 posted by sock on 2010/03/05 10:54:48
I meant RickyT23, sorry.
 Sock
#18183 posted by Jago on 2010/03/05 11:02:30
Hop on a plane to Finland and I will buy you a few beers :)
 Heh - Cool Man I Know A Few Good Pubs
#18184 posted by RickyT33 on 2010/03/05 11:50:09
If you were to drive to junction 40 on the M6 you would be 2 minutes from me, literally :)
Guilford is like south west London. Ouch. That's a bit of a treck.
 Come To Chile For A Beer...
#18185 posted by ijed on 2010/03/05 12:04:39
...stay to work in an NGO!
 "OSX Quakespasm Binary"
#18186 posted by Baker on 2010/03/05 12:05:26
@stevenaaus
Do you have a link to it, I browsed around and am not seeing one?
 Sock
#18187 posted by Vigil on 2010/03/05 15:55:31
There's almost as many Finns frequenting this board as Brits, and we're much closer to each other.
 Popular Science Archive Online
#18188 posted by Zwiffle on 2010/03/05 16:10:12
137 years of Popular Science online
http://www.popsci.com/archives
#18189 posted by cardo on 2010/03/05 17:15:00
Vig, that doesn't really help the british people here ;) Obviously I'm up for it sock. Due to my lack of job I don't have too much cash to be travelling too far but am definitely up for a drinkie.
#18190 posted by ijed on 2010/03/05 18:22:51
and we're much closer to each other.
Yes - the British are a cold people, unlike the warm hearted Finnish.
 Mac Binary
#18191 posted by stevenaaus on 2010/03/05 19:46:40
It's happenning. We've got it compiled and going... but are still working on the best way to distribute it with SDL & SDL_net libs and still get it to find "/id1".
#18192 posted by stevenaaus on 2010/03/05 19:52:21
 Hmm
#18193 posted by nonentity on 2010/03/06 00:41:32
Meh, random ldn pub is easy...
Oh yeh, I moved. Cardo, come see meh ;p
 Bioshock Arcadia Doom2
#18194 posted by stevenaaus on 2010/03/06 02:50:22
Big sprawling map, with some entertaining fighting. As a bit of a timewaster it's ok, but I never played Bioshock.
 Php/sql Question
#18195 posted by Spirit on 2010/03/06 09:34:15
What is a reasonable time a page should take to load? And are there some general tricks to reduce it apart from thinking, output buffering and using good queries?
The new Quaddicted listing currently takes about 200ms. The details page is fast, 20-40ms. Is that good? Overall hits for those pages are very low hundreds per day.
I am using sqlite3 and php.
 I Should Add
#18196 posted by Spirit on 2010/03/06 09:35:51
the listing took ~30ms without the tags. Those are joined from another table. Maybe I should store them as string in the maps table too. But that sounds like more work and not too easy.
#18197 posted by mwh on 2010/03/06 12:28:05
200ms is ok really. If you want to make it faster you could try a caching reverse proxy like varnish, or shoving bits of the page in mamcache. but remember the almost fundamental truth if caching: if you cache, you will sometimes be serving out of date data - and decide if you care (i bet you don't)
Sqlite is pretty fast but doesn't cope with concurrency all that well - if the number of concurrent requests starts climbing, you might want to try postgres or mysql instead.
 Nope
#18198 posted by SleepwalkR on 2010/03/06 13:02:56
200ms is not ok I think, it should be faster. If I understand correctly, the problem arises with the use of tags from another database table. You say you are joining them in - are you sure that you set all indices correctly? What kind of join do you use? Also, you should definitely consider using mysql because since SQLite is serverless, it cannot cache any data between queries.
 I'd Say
#18199 posted by megaman on 2010/03/06 15:15:51
just build some simple caching mechanism. Save the output into a file, check if the file is older than 5mins. that will protect you against /.ing as much as possible with almost no implementation overhead.
#18200 posted by Spirit on 2010/03/06 19:21:28
I will not use mysql, I like the single files db with sqlite. And with a project this small it should not matter too much. The spmaps.html gets <<10000 hits per month. That's <300 per day, one all >4 minutes. :)
My query:
SELECT *, GROUP_CONCAT(DISTINCT tag) AS tags FROM maps LEFT JOIN tags ON maps.id = tags.mapid GROUP BY maps.id ORDER BY maps.id
maps has a lot of columns. tags only
Currently the maps.id is (oops) TEXT PRIMARY KEY, tags.mapid is TEXT. I will have a INTEGER PRIMARY KEY for the maps.id (and thus use INTEGER for tags.mapid too) in the end, maybe that will help a bit (was a stupid oversight when I started tinkering).
megaman: Cheers, already created that for an old project once:
$filename = 'blah.html';
$lastupdate = filemtime($filename);
$currenttime = time();
$timesincelastupdate = $currenttime - $lastupdate;
if ($timesincelastupdate > 300) { //rerender the file }
 But
#18201 posted by megaman on 2010/03/06 20:35:43
don't forget proper headers and it might be a nice idea to put the caching check into the php start section:
http://paste2.org/p/704653
#18202 posted by mwh on 2010/03/07 08:47:46
Well, you can always try "explain"ing your query, try "explain SELECT *, GROUP_CONCAT(DISTINCT tag) AS tags FROM maps LEFT JOIN tags ON maps.id = tags.mapid GROUP BY maps.id ORDER BY maps.id", you might be able to tell if you're missing an index or something-- but it looks like sqlite gives fairly incomprehensible results for this...
 Map On The Edge Of Forever
#18203 posted by sock on 2010/03/07 08:52:16
Screenshot : http://www.simonoc.com/files/maps/q3/moteof_final.jpg
Here is the final release of a map that some of you may have seen over the last 8 months via the mountain of screenshots I have drowned this forum in and wondered 'what is going on here!'. It has been a very long journey for me with countless builds and months of building but thanks to all my friends it has been an amazing experience. :)
As always, constructive comments are welcome and if you have the chance to record any demo's please let me know because I would love to see how you played the map. I do understand that this will not be everyone's cup of tea because it has a very strong puzzle element but take your time and try to resist the urge to noclip around the place. All the source files and a detailed explaination of the map will be released next week. The website does contain some help on how to find things if you are really stuck!
Zip File : http://www.simonoc.com/files/maps/q3/moteof_final.zip (49Mb)
Website : http://www.simonoc.com/pages/design/maps_q3/moteof.htm
|