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 

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 :) 

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 :) 

I meant RickyT23, sorry. 

Hop on a plane to Finland and I will buy you a few beers :) 

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. 

...stay to work in an NGO! 

@stevenaaus

Do you have a link to it, I browsed around and am not seeing one? 

There's almost as many Finns frequenting this board as Brits, and we're much closer to each other. 

137 years of Popular Science online
http://www.popsci.com/archives 

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. 

and we're much closer to each other.

Yes - the British are a cold people, unlike the warm hearted Finnish. 

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". 

Does this Makefile.darwin work/help.
http://quakespasm.sourceforge.net/tmp/Makefile.darwin 

Meh, random ldn pub is easy...

Oh yeh, I moved. Cardo, come see meh ;p 

Big sprawling map, with some entertaining fighting. As a bit of a timewaster it's ok, but I never played Bioshock. 

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. 

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. 

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. 

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. 

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. 

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 } 

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 

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... 

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