Results 1 to 7 of 7
  1. #1
    New Project Manager






    Join Date
    Feb 2008
    Posts
    14,819
    SCF Rewards
    65,020
    Blog Entries
    16
    Country
    Montreal Canadiens
    See coolhandluke907's Items on eBay

    Player indexing explained

    Search just a sport and a player name in hockey take 24 seconds and more if you query Baseball. Why, because search for partial text is slow. The only way around was to create a player table and index them one by one. What we did is let member index the player they need as it very long to do so. Hockey has only index 1/3 as of today of all 30,000 player we have for hockey.

    When search for a player you need to use the full player name in the search so the index kick in. You can watch this demo that show you how to work a player list and you can always as a OPG staff to optimise a player for you that you collect.

    Here the demo/video:
    This Ad will be removed when you a member of sportscardforum.com



    http://www.sportscardforum.com/demo/..._indexing.html

    0 Not allowed! Not allowed!
    Hidden Content

    I collect all Montreal Canadien. Hidden Content for player, teams you collect

  2. #2




    Join Date
    Mar 2012
    Posts
    94
    SCF Rewards
    250
    Blog Entries
    3
    Country

    I am having some troubles trying to set up a player index for Frank Thomas (The Big Hurt). The trouble comes because there are two Frank Thomas's who played in the MLBs. Right now, both players show 0 cards in their index. How can I create an index for one without adding cards from the other?

    0 Not allowed! Not allowed!

  3. #3





    Join Date
    Oct 2006
    Posts
    3,638
    SCF Rewards
    0
    Blog Entries
    3
    Country
    Twitter: @DaClyde See daclyde1's Items on eBay Packrip.com Traders COMC Cards For Sale Kronozio

    The only solution I've come up with so far is to add a middle initial to the name of the player with the fewer cards and index that way. Unfortunately I found there were something like 5 different Juan Gonzalezes and I haven't been able to find a middle initial for one of them.

    I did that for Ryan Braun, too, to separate the pitcher from the outfielder.

    0 Not allowed! Not allowed!

  4. #4





    Join Date
    Oct 2006
    Posts
    3,638
    SCF Rewards
    0
    Blog Entries
    3
    Country
    Twitter: @DaClyde See daclyde1's Items on eBay Packrip.com Traders COMC Cards For Sale Kronozio

    Ok, I've indexed both Franks. Have a look and see if there are any obvious errors.

    0 Not allowed! Not allowed!

  5. #5




    Join Date
    Jan 2012
    Posts
    2,234
    Country
    See phenomenalcards's Items on eBay

    If you get a chance, could you add Brandon Harris to the index?

    0 Not allowed! Not allowed!

  6. #6




    Join Date
    Mar 2012
    Posts
    94
    SCF Rewards
    250
    Blog Entries
    3
    Country

    Ok, I've indexed both Franks. Have a look and see if there are any obvious errors.

    Thank you, I really appreciate you doing that. Except for the fact that I was feeling good about my collection until I realized how incredibly small it is in the grand scheme of things.

    0 Not allowed! Not allowed!

  7. #7
    New Project Manager






    Join Date
    Feb 2008
    Posts
    14,819
    SCF Rewards
    65,020
    Blog Entries
    16
    Country
    Montreal Canadiens
    See coolhandluke907's Items on eBay

    Thank you, I really appreciate you doing that. Except for the fact that I was feeling good about my collection until I realized how incredibly small it is in the grand scheme of things.

    Stats are only that, stats, you should not let this make you feell different about your collection. A collection also grow over time.

    0 Not allowed! Not allowed!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
SCF Sponsors


About SCF

    Sports Card Forum provides sports and non-sports card collectors a safe place to discuss, buy, sell and trade.

    SCF maintains tools that will allow collectors to manage their collections online, information about what is happening with the hobby, as well as providing robust data to send out for Autographs through the mail.

Follow SCF on