Posted under General
I dont know why, but in search dont work tag short_hair combine with order:score or order:favcount. After searching this tag together showing steatment: ERROR: canceling statement due to statement timeout . I dont find any other combinations which dont work in searching. Sorry for my bad english.
With just a member-level account, you have a database timeout of only 3 seconds. If the search is unable to complete within that time period, the request will cancel out.
I timed the search short_hair order:score, and it was somewhere between 3-6 seconds.
For more information on what your member level can and cannot do, see help:users.
Thanks for You help. But still isn't clear for me why only this tag. No exactly know how work this database, but if in this case it was just only time, searching same order:score or combine with tag like 1girl, breast or long_hair should deal way more time, but this work. I wrote that's searching don't work but one time this worked ( I'm no should grammar in this sentence) and after changing page statement show up again.
Access times to the database can vary based on a multitude of factors. Some factors are more solid such as search terms, and others can be transient such as server load.
So basically, no two searches will be the same, and what works one day may not work the next, and vice versa.
I was just looking at this and it turns out it's because post scores are unindexed. I'm surprised it works at all. I could've sworn scores were indexed, even obscure things like order:filesize and order:mpixels are. @Type-kun do you know anything about this? Was it dropped at some point or have we really not had it the whole time?
I have no idea why long_hair order:score is consistently much faster than short_hair order:score though. That one is a mystery.
evazion said:
I was just looking at this and it turns out it's because post scores are unindexed. I'm surprised it works at all. I could've sworn scores were indexed, even obscure things like order:filesize and order:mpixels are. @Type-kun do you know anything about this? Was it dropped at some point or have we really not had it the whole time?
Huh. Actually, I'm not sure about this myself, but going by migrations it seems that we never had it. Albert is (or was, anyway) reluctant to add more indexes to posts table since it supposedly made uploads time-out due to write delay; maybe it got better, though?
