Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->General: Website Discussion Page: 1 2  Previous   Next
Search function
Author Message
Invelos Software, Inc. RepresentativeKen Cole
Invelos Software
Registered: March 10, 2007
United States Posts: 4,282
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
The website forum search function has been significantly improved.  It should no longer timeout regularly, and the results should be significantly more relevant.

Let me know if you see any sort of wonkiness.
Invelos Software, Inc. Representative
 Last edited: by Ken Cole
DVD Profiler Unlimited RegistrantStar ContributorAddicted2DVD
Registered: March 13, 2007
Reputation: Highest Rating
United States Posts: 17,308
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Just tried it out... a little on the slow side (maybe because I chose any date)... but worked nicely. Allowed me to find a thread I wanted to bump in the Feature Request forum.

Thanks Ken! 
Pete
DVD Profiler Unlimited RegistrantStar Contributorbbbbb
on steroids
Registered: March 14, 2007
Posts: 5,734
Posted:
PM this userDirect link to this postReply with quote
Don't know why, but searched for "ADR" (DVD Profiler -> Contribution Discussion, Any Date).

Not only that the search did not timeout. There were findings.
Don't confuse while the film is playing with when the film is played. [Ken Cole, DVD Profiler Architect]
DVD Profiler Unlimited RegistrantStar ContributorMerrik
NON-STEPFORD PROFILER
Registered: September 30, 2008
Reputation: Highest Rating
Canada Posts: 1,805
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
It's been so long since I've used it, I couldn't remember where to actually find the search function.

Tried out a search (for an old common name thread that's probably on page 150 of the contribution forums) and sure enough, it actually turned up results. Nice.

It'll be a lot easier now to search for things like BY's (to add verification to contribution notes).

Thanks Ken. Much appreciated correction to the forums.

The night is calling. And it whispers to me soflty come and play.
DVD Profiler Unlimited Registrantnuoyaxin
prev. known as ya_shin
Registered: March 13, 2007
Reputation: High Rating
Taiwan, Province of China Posts: 3,432
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Achim [諾亞信; Ya-Shin//Nuo], a German in Taiwan.
Registered: May 29, 2000 (at InterVocative)
DVD Profiler Unlimited RegistrantStar ContributorKatatonia
Retired Profiler
Registered: March 13, 2007
Reputation: Highest Rating
United States Posts: 20,111
Posted:
PM this userDirect link to this postReply with quote
Thanks Ken!
Corey
DVD Profiler Unlimited RegistrantBlair
Resistance is Futile!
Registered: October 30, 2008
United States Posts: 1,249
Posted:
PM this userDirect link to this postReply with quote
Quoting Merrik:
Quote:
It's been so long since I've used it, I couldn't remember where to actually find the search function.

That was my first reaction as well.


The search function went from always timing out to extremely fast for me. I don't remember how it worked before (It's been so long since I tried it,) but I like how it handles partial matches.
If at first you don't succeed, skydiving isn't for you.

He who MUST get the last word in on a pointless, endless argument doesn't win. It makes him the bigger jerk.
DVD Profiler Desktop and Mobile RegistrantDr. Killpatient
Here's my card
Registered: May 19, 2007
Reputation: Highest Rating
United States Posts: 5,916
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Created indexes?

That's my guess as the forum would become unresponsive as a whole if someone performed a search.

Now to see if I can likewise remember where the search button is....
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,396
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Fantastic. Just answered a question without making a new post or thread. Turns out my question had been answered a bunch of times before. So the increase in search traffic might be balanced by a somewhat lesser load of repeat questions and duplicate threads. Too bad Ken doesn't allow us to give him greenies! 
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting mediadogg:
Quote:
Too bad Ken doesn't allow us to give him greenies! 


I've thought that myself from time to time.  On the other hand, he can also give himself 5 stars.  So I don't feel too bad for him.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
Invelos Software, Inc. RepresentativeKen Cole
Invelos Software
Registered: March 10, 2007
United States Posts: 4,282
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Dr. Killpatient:
Quote:
Created indexes?
That's my guess as the forum would become unresponsive as a whole if someone performed a search.


Ahh if only it were that simple.   The proper indices were in place long ago, and MS' full text search engine as well.  I had banged my head on this a while ago and had run into an interesting symptom - the query ran fine via query analyzer, but routinely timed out when run via the web page.

When I decided to tackle this again the other day, I rewrote the search to use a stored procedure rather than generated sql, and along the way improved the query quite a bit. (I've learned a bit since I originally wrote it. )

When I was done, I had it very performant compared to the prior version.  Yet in the end I discovered that the query ran fine (many searches are sub-second) when run directly in the query analyzer, but again consistently timed out when running the stored procedure. I had been blaming asp.net for the problem, but now could remove it from the investigation.

This led me to the culprit - something sql server does called parameter sniffing.  Certain cases confuse the hell out of the optimization engine.  The solution in this case was simply to redefine the passed parameters as local variables, and just set them to the passed values.  This apparently causes a reset of the optimization and in this case solved the problem.

Also, thanks for the notion on the greenies, but as you can see at the left, I'm green enough already! 
Invelos Software, Inc. Representative
 Last edited: by Ken Cole
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
We have a guy at work (we call him Mr. Optimize-Prime) who does nothing but optimizing database stuff.  His most recent work was a stored procedure that took 60+ minutes to run in production and got it down to 30+ SECONDS.

Yes, he's earned his nickname!
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantStar ContributorKulju
Registered: March 14, 2007
Finland Posts: 2,337
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Aaaarghhh, Search page has now the same problem as CLT page. If you hit enter the page will sign you out. This is a MOST annoying feature. Could you please fix it Ken? I remember that there was another thread about this issue, but I cannot find it at the moment and I don't want to use Search
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,216
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Kulju:
Quote:
Aaaarghhh, Search page has now the same problem as CLT page. If you hit enter the page will sign you out. This is a MOST annoying feature. Could you please fix it Ken? I remember that there was another thread about this issue, but I cannot find it at the moment and I don't want to use Search

clickety

Works a expected under Opera 11.62
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
 Last edited: by Mithi
DVD Profiler Unlimited RegistrantStar ContributorKulju
Registered: March 14, 2007
Finland Posts: 2,337
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Mithi:
Quote:

Works a expected under Opera 11.62

So it works correctly with a browser that's been used by 1,62% of browser users. Not a big help
Alt + Q doesn't do anything, but I assume that you mean Compatibility View mode, since that seems to work. I stil feel that the webpage fix would be better solution.
DVD Profiler Desktop and Mobile RegistrantStar Contributormreeder50
I was outta bullets
Registered: March 29, 2007
Reputation: Superior Rating
United States Posts: 2,713
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
I have been using Chrome for about a year now and the fixed search function is great. Thus far it only takes a couple seconds to search the entire website and get a result. Thanks for fixing this Ken, I no longer have to use the Google site search.
Marty - Registered July 10, 2004, User since 2002.
    Invelos Forums->General: Website Discussion Page: 1 2  Previous   Next