Forum search is bac...
 

Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop

[Closed] Forum search is back...

29 Posts
18 Users
0 Reactions
106 Views
Posts: 0
Free Member
Topic starter
 

I am assuming that this hasn't been posted yet (unless it happened in the last 20 minutes and didn't turn up in the search).
Can't say I missed it, but I know many of you will now heave a huge sigh of relief.
[url= http://www.singletrackworld.com/blogs/2010/04/forum-search-returns/ ]Hampster related news here.[/url]


 
Posted : 07/04/2010 1:17 pm
Posts: 14050
Free Member
 

Yay......... seriously....... YAY 🙂


 
Posted : 07/04/2010 1:33 pm
Posts: 14649
Free Member
 

[b][i][u][center][size=5][color=red]YAY![/color][/size][/center][/u][/i][/b]

Thank fricken god, it was causing me loads of stress, even had a thread about it.. no matter what I did I couldn't get the google search to work well.


 
Posted : 07/04/2010 1:35 pm
Posts: 0
Free Member
 

yeah i couldnt get on with google either, welcome back forum search-pipe and slippers where you left em old bean


 
Posted : 07/04/2010 1:36 pm
Posts: 11381
Free Member
 

People who use "Simples" Should be culled

No Exceptions - Sorry Tom

*Loads gun*


 
Posted : 07/04/2010 1:36 pm
Posts: 14649
Free Member
 

Old Hammie's looking good...

[img] [/img]


 
Posted : 07/04/2010 1:40 pm
 Drac
Posts: 50455
 

[img] [/img]


 
Posted : 07/04/2010 1:47 pm
Posts: 0
Free Member
Topic starter
 

Hound- I have to disagree, as someone who has downloaded the free comparethemarket.com app to his iPod touch I have to say "simples" is the least of the crimes 🙂


 
Posted : 07/04/2010 2:05 pm
Posts: 19914
Free Member
 

Why do people continually spell HAMSTER with a P in the middle?

Do you pronounce it hamPster?

Or has it bred with a hamPer?


 
Posted : 07/04/2010 2:06 pm
Posts: 0
Free Member
 

PP, just pretend it's an homage to Andy Hampsten.


 
Posted : 07/04/2010 2:16 pm
Posts: 464
Free Member
 

the hamster told me to say it.


 
Posted : 07/04/2010 2:46 pm
Posts: 621
Free Member
 

Cheers admins, that's much better


 
Posted : 07/04/2010 3:40 pm
Posts: 11507
Full Member
 

Thanks, much more usable 🙂


 
Posted : 07/04/2010 4:18 pm
Posts: 0
Free Member
 

It's usable whereas Google was not. Tom: how are you getting around the problem of maxing-out the server?


 
Posted : 07/04/2010 4:21 pm
 Tom
Posts: 0
Free Member
 

*Loads gun*

Never aim a loaded gun at a man armed with iptables. 😮

We are basically using some replication, which means the search searches a different table than the one being posted to. The posts get copied over to the searchable bit, currently every 20 minutes and people can search that copy for 'mtb' all they want (yes they do that, lots) without any INSERTs getting in the way. This replication prevents the table locking that used to give rise to the occasional shonky database connection errors as the queue of read threads became overwhelming. We've used a variety of workarounds before, but this time it's a fairly solid fix.

Welcome.
[url= http://dev.mysql.com/doc/refman/5.0/en/table-locking.html ]more details of the defeated problem[/url]


 
Posted : 07/04/2010 4:59 pm
 Drac
Posts: 50455
 

WOW! Who said IT was boring. 😯


 
Posted : 07/04/2010 5:00 pm
Posts: 8850
Free Member
 

Thank you Tom db 🙂


 
Posted : 07/04/2010 5:42 pm
Posts: 0
Free Member
 

Good job Tom


 
Posted : 07/04/2010 6:36 pm
Posts: 0
Free Member
 

I'm missing from the drop down user listing!


 
Posted : 12/04/2010 8:20 am
Posts: 0
Free Member
Topic starter
 

Does the list come from your original username and you have changed yours? Possibly?
Or have you upset Tom at some point?


 
Posted : 12/04/2010 8:24 am
Posts: 14649
Free Member
 

I had the same issue when trying to look for "undapressure" posts, not listed in the drop down menu.


 
Posted : 12/04/2010 9:20 am
 Tom
Posts: 0
Free Member
 

The user list is currently restricted to the first 3,000 users, otherwise the list would be even more huge (nearly 1Mb by my calculations). I'll see what can be done, but it's a bit of a sensible default limit. You can always see what a user's posted by looking at their profile.


 
Posted : 12/04/2010 10:26 am
Posts: 24
Free Member
 

Big improvement. Ta.


 
Posted : 12/04/2010 10:32 am
Posts: 14649
Free Member
 

[i]You can always see what a user's posted by looking at their profile.[/i]

Yes but I wanted to search his posts... looking for some info on item he was offering for sale.

Obvious question that has to be ask (even if the answer is obvious to you...), why can you not just enter the user's name as another search field, without listing the registered users?

EDIT: Still very happy to have it back ❗


 
Posted : 12/04/2010 10:32 am
 Tom
Posts: 0
Free Member
 

Simple but equally obvious answer: because that's the way it was written. The issue has been noted; we'll take a look at how it can be improved. It'll require some meditation.


 
Posted : 12/04/2010 10:48 am
Posts: 0
Free Member
 

[url= http://www.singletrackworld.com/forum/search.php?q=what+tyres&x=0&y=0 ]Hell yeah![/url]


 
Posted : 12/04/2010 11:15 am
 Tom
Posts: 0
Free Member
 

Having meditated I can announce that anyone who has posted recently is now in the list 😀 It doesn't display every user we have, and z1ppy's suggestion hasn't been implemented, but that'll be one of those longer term projects we can look forward to.


 
Posted : 12/04/2010 6:07 pm
 Drac
Posts: 50455
 

Good work Tom.


 
Posted : 12/04/2010 6:13 pm
Posts: 14649
Free Member
 

fair enuff 🙂


 
Posted : 13/04/2010 9:40 am
Posts: 0
Free Member
 

Car inshoooorance!


 
Posted : 13/04/2010 10:04 am