nentwined
18 Apr 2004
Reply
Fav(orite)s: like 'em, love 'em, hate 'em?
26 replies
When can we expect a POEM/COMMENT TEXT SEARCH?
When I come up with a way for them to not flood the system. :)
They'd do that? That sounds terrible! Actually, I have no idea what you mean, having made a point of never learning anything with a practical application.
Do you mean because _so_many_people_ would perform them?
Do you mean because _so_many_people_ would perform them?
Freeform text searches are kind of expensive to start with, when you're not doing anything in particular to speed them up (like periodically dumping every "word" of a poem/comment into some sort of lookup table). There are a lot of long poems and long comments in the database.
Then again, a search for 'the' (matches tHe and TheRe) gives 38,634 hits in the span of 939.89 msec. That's not so bad, really. The next question would be how to sort and page through those, but I could do something 'stupid' easily enough (like sorting by date entered into the system, showing up to... 100 results at a time or something).
Hmm.
Then again, a search for 'the' (matches tHe and TheRe) gives 38,634 hits in the span of 939.89 msec. That's not so bad, really. The next question would be how to sort and page through those, but I could do something 'stupid' easily enough (like sorting by date entered into the system, showing up to... 100 results at a time or something).
Hmm.
You could provide a complete copy of the poemeranker archives by email on request, and let the user do their own fucking text processing to their heart's content. How big is bzip2ed text?
Speaking of archives, do you happen to have saved the vipersna/Journey debacle? I'm trying to collect leaving rants, and that was one of the biggest bust-ups ever, but it was deleted before I thought to save a copy. Thanks so fucking much.
It probably exists, but I wouldn't know where to go looking for it. but I know what you mean--I keep happening upon waybackmachine archives of things I'd completely forgotten about.
If you type "leaving" into the new comment search engine, you get hits for something deleted on 5-Nov-03 but the comments don't show up in anyone's regular comments page. That's the time when -=D_A=- wrote: "Oh man, I hardly ever get to tick the leaving rant box. This is almost certainly the poeme with the highest mediocrity score of all time. Sir, I pull down my trousers and salute you."
You also get horus running ItalyAngel off on a deleted poem around 4-Oct-03. And "Poem for Preps" by Brittanyy.
Also, the search terms "goodbye" and "good-bye" look really promising.
You also get horus running ItalyAngel off on a deleted poem around 4-Oct-03. And "Poem for Preps" by Brittanyy.
Also, the search terms "goodbye" and "good-bye" look really promising.
Actually, the Vipersna thing is still there. Type "Vipersna" in the comment search.
Genius!
dump of entire poemranker database bzip2s to seventeen megs.
give it a whirl.
Thanks. It's awesome.
That + a top hat = hump all night
I tried to remove that gay laundry poeme from my favourites list, resulting in the following disgrace:
Error:
Sorry about that. Not sure what happened, but it wasn't pretty.
Please email kaolin.fire@poemranker.com and appraise him/her/it of the situation!
(what you were trying to do, what page you were at, what link you clicked, and all that good stuff) -- and most of all, the info below.
The column name ownerid not found.
at org.postgresql.jdbc2.ResultSet.findColum
at org.postgresql.jdbc2.ResultSet.getLong(R
at com.poemranker.Fav.init(Fav.java:125)
at com.poemranker.Fav.(Fav.java:38)
at _user_22dfavorites_22ddrop_22dprocess__j
at com.caucho.jsp.JavaPage.service(JavaPage
at com.caucho.jsp.Page.subservice(Page.java
at com.caucho.server.http.FilterChainPage.d
at com.caucho.server.http.Invocation.servic
at com.caucho.server.http.CacheInvocation.s
at com.caucho.server.http.HttpRequest.handl
at com.caucho.server.http.HttpRequest.handl
at com.caucho.server.TcpConnection.run(TcpC
at java.lang.Thread.run(Thread.java:536)
Error:
Sorry about that. Not sure what happened, but it wasn't pretty.
Please email kaolin.fire@poemranker.com and appraise him/her/it of the situation!
(what you were trying to do, what page you were at, what link you clicked, and all that good stuff) -- and most of all, the info below.
The column name ownerid not found.
at org.postgresql.jdbc2.ResultSet.findColum
at org.postgresql.jdbc2.ResultSet.getLong(R
at com.poemranker.Fav.init(Fav.java:125)
at com.poemranker.Fav.(Fav.java:38)
at _user_22dfavorites_22ddrop_22dprocess__j
at com.caucho.jsp.JavaPage.service(JavaPage
at com.caucho.jsp.Page.subservice(Page.java
at com.caucho.server.http.FilterChainPage.d
at com.caucho.server.http.Invocation.servic
at com.caucho.server.http.CacheInvocation.s
at com.caucho.server.http.HttpRequest.handl
at com.caucho.server.http.HttpRequest.handl
at com.caucho.server.TcpConnection.run(TcpC
at java.lang.Thread.run(Thread.java:536)
try now?
Everything's just dandy
And now I have to make another spurious comment.