Wednesday, April 10, 2013

Profile Builder Search Super Optimization and Boolean Search Optimization





http://wordpress.org/extend/plugins/profile-builder/
Profile Builder is WordPress registration done right and also creates custom profiles.




I purchased the Extended WP Profile Builder PRO Plug-in with Advanced User Listing including Search. But I found this search to be very slow. 

I re-wrote the search to be super optimized query, which reduces search time from avg 1.87s (with 10 users in database) reduced to 0.016s which is  99.1% quicker,  or 2 orders of magnitude quicker.

Moreover, I add default fields from wordpress to search as well including username, email and first and last name. The search is much more robust this way. 

See in action, live at 
http://bcicac.com/resources/selecting-a-panellist/

Please contact me for the sale of this solution. 

Profile Builder Improved Search Request Form

Name
Email *
Message *



Moreover, I have developed and implemented my proprietary search called Logicktronic Search for PHP.

Logicktronic Search will take any search string and try to make sense out of the input in terms of the Boolean operators (and, or) that are used. Moreover, Logicktronic Search implements search for an exact word or phrase by using double quotes to delineate phrases. 

For example, lets take the following search examples; 


  1. Fred "Accounting Financial Services" 

    CORRECTED SEARCH ->  
    Fred OR "Accounting Financial Services"

    EXPLANATION: Added OR to make clear of Boolean operand used
  2. Fred and or and "Accounting Financial Services"

    CORRECTED SEARCH ->  Fred AND "Accounting Financial Services"

    EXPLANATION: Reduced Boolean operators to first one
  3. Fred or and "Accounting and Financial or Services"

    CORRECTED SEARCH ->  
    Fred OR "Accounting and Financial or Services"

    EXPLANATION: Reduced Boolean operators to first one, and search phrase is preserved.
  4. Fred Wilma and Barney or or and or "The Flintstones" 

    CORRECTED SEARCH ->  
    Fred OR Wilma AND Barney OR "The Flintstones"

    EXPLANATION: Will reduced any number of combination of Boolean operators to first one, and search phrase is preserved.

Please contact me for the sale of the solution.



No comments:

Post a Comment