News | Forum | People | FAQ | Links | Search | Register | Log in
General Abuse
Talk about anything in here. If you've got something newsworthy, please submit it as news. If it seems borderline, submit it anyway and a mod will either approve it or move the post back to this thread.

News submissions: https://celephais.net/board/submit_news.php
First | Previous | Next | Last
Close Encounter? 
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? 
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... 
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 
I meant RickyT23, sorry. 
Sock 
Hop on a plane to Finland and I will buy you a few beers :) 
Heh - Cool Man I Know A Few Good Pubs 
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... 
...stay to work in an NGO! 
"OSX Quakespasm Binary" 
@stevenaaus

Do you have a link to it, I browsed around and am not seeing one? 
Sock 
There's almost as many Finns frequenting this board as Brits, and we're much closer to each other. 
Popular Science Archive Online 
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. 
Mac Binary 
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 
Hmm 
Meh, random ldn pub is easy...

Oh yeh, I moved. Cardo, come see meh ;p 
Bioshock Arcadia Doom2 
Big sprawling map, with some entertaining fighting. As a bit of a timewaster it's ok, but I never played Bioshock. 
Php/sql Question 
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 
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. 
Nope 
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 
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 }
 
But 
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... 
Map On The Edge Of Forever 
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 
First | Previous | Next | Last
You must be logged in to post in this thread.
Website copyright © 2002-2025 John Fitzgibbons. All posts are copyright their respective authors.