Results 1 to 14 of 14

Thread: Adding new link with a lots of categories

  1. #1
    aladdin1 is offline Active Member
    Join Date
    Feb 2004
    Posts
    455

    Default Adding new link with a lots of categories

    Hello,

    I just build a new directory with a little over 7000 categories. I am now unable to add new links, it seems that the add.php script time out.
    I think it is due to the fact that the script is trying to build an add page with 2 7000 drop down fieldds. How can I keep the script from trying to build this 2 dropdown fields?
    As anyone build a directory with a lots of categories, did you have to do something special? What?

  2. #2
    dody is offline Administrator
    Join Date
    Aug 2001
    Location
    Indonesia
    Posts
    3,731

    Default

    You have too many categories. The category dropdown list could make indexu produce timeout because it's too long and the file size is too big.
    www.nicecoder.com
    www.dodyrw.com

  3. #3
    esm's Avatar
    esm
    esm is offline Active Member
    Join Date
    Apr 2003
    Location
    Atlanta GA
    Posts
    3,395

    Default

    Quote Originally Posted by aladdin1
    As anyone build a directory with a lots of categories, did you have to do something special? What?
    not that your solution depends on it but what version of INDEXU are you using?

    A couple of things. First, If you don't use related categories, just comment them out in the add.php page and remove them from the HTML page.

    Second, I won't even pretend to understand the INDEXU code that builds the categories (but then I just looked at it without trying to follow it ). But it sure looked complicated to me. It has to make two SQL queries and that can be time-consuming with over 7,000 cats. Then there is some ADODB code that further compounds the problem.

    I did develop a dropdown category function for my LinksCoder program that handled over 5,000 categories (but I think INDEXU handled that too). Maybe that would work for you.



    .
    esm
    "The older I get, the more I admire competence, just simple competence, in any field from adultery to zoology."

    .

  4. #4
    aladdin1 is offline Active Member
    Join Date
    Feb 2004
    Posts
    455

    Default

    Quote Originally Posted by dody
    You have too many categories. The category dropdown list could make indexu produce timeout because it's too long and the file size is too big.
    Thank you for confirming my diagnostic. How do I keep Indexu from building dropdown list. I did remove it from the template but it did not do the trick. I will forgo the ability to input the same link in several categories.

  5. #5
    esm's Avatar
    esm
    esm is offline Active Member
    Join Date
    Apr 2003
    Location
    Atlanta GA
    Posts
    3,395

    Default

    Quote Originally Posted by aladdin1
    Thank you for confirming my diagnostic. How do I keep Indexu from building dropdown list. I did remove it from the template but it did not do the trick. I will forgo the ability to input the same link in several categories.
    remove or comment out the following lines in add.php

    Code:
      $add_cat1 = str_replace("<select name=cat>","<select name=add_cat1>",$category_obj->DisplayCategoryListBox(-1));
      $add_cat1 = str_replace("<OPTION VALUE=''>","<OPTION VALUE='0'>",$add_cat1); 
      $add_cat2 = str_replace("<select name=cat>","<select name=add_cat2>",$category_obj->DisplayCategoryListBox(-1));
      $add_cat2 = str_replace("<OPTION VALUE=''>","<OPTION VALUE='0'>",$add_cat2);
    esm
    "The older I get, the more I admire competence, just simple competence, in any field from adultery to zoology."

    .

  6. #6
    aladdin1 is offline Active Member
    Join Date
    Feb 2004
    Posts
    455

    Default

    Quote Originally Posted by esm
    remove or comment out the following lines in add.php

    Code:
      $add_cat1 = str_replace("<select name=cat>","<select name=add_cat1>",$category_obj->DisplayCategoryListBox(-1));
      $add_cat1 = str_replace("<OPTION VALUE=''>","<OPTION VALUE='0'>",$add_cat1); 
      $add_cat2 = str_replace("<select name=cat>","<select name=add_cat2>",$category_obj->DisplayCategoryListBox(-1));
      $add_cat2 = str_replace("<OPTION VALUE=''>","<OPTION VALUE='0'>",$add_cat2);

    I did do that but it does not seem to help. You can see it at:
    http://Healthandhealers.com
    I thought that something some where was still building the dropdown list. Am I wrong?
    Last edited by aladdin1; 03-12-2006 at 08:35 PM.

  7. #7
    esm's Avatar
    esm
    esm is offline Active Member
    Join Date
    Apr 2003
    Location
    Atlanta GA
    Posts
    3,395

    Default

    Quote Originally Posted by aladdin1
    should be http://Healthandhealers.com

    kind of hard to say for sure without actually looking at the code.



    .
    esm
    "The older I get, the more I admire competence, just simple competence, in any field from adultery to zoology."

    .

  8. #8
    aladdin1 is offline Active Member
    Join Date
    Feb 2004
    Posts
    455

    Default

    Quote Originally Posted by esm
    should be http://Healthandhealers.com

    kind of hard to say for sure without actually looking at the code.

    .
    Yes you are right, it is:
    http://www.healthandhealers.com

    Do you wnat to look at the code. I did spend a lots of time getting the data, I will hate not to be able to post it.

    Thierry

    PS. I may have a server problem, I am not able to reach any of my sites.

  9. #9
    aladdin1 is offline Active Member
    Join Date
    Feb 2004
    Posts
    455

    Default Amusing!!

    I load add.php from Indexu 3.04. and it is working, kind of strange isn't it?

  10. #10
    dody is offline Administrator
    Join Date
    Aug 2001
    Location
    Indonesia
    Posts
    3,731

    Default

    Indexu 5.0.2 no longer use ADODB and we implement our own database library which is faster and smaller. I'm sure indexu still can hold 7000 categories. I'll make a test today with large number of categories.
    www.nicecoder.com
    www.dodyrw.com

  11. #11
    aladdin1 is offline Active Member
    Join Date
    Feb 2004
    Posts
    455

    Default

    Quote Originally Posted by dody
    Indexu 5.0.2 no longer use ADODB and we implement our own database library which is faster and smaller. I'm sure indexu still can hold 7000 categories. I'll make a test today with large number of categories.
    Hello,

    Thank you for your reply. I was not trying to blame you or the application, 7000 categories might be un-reasonable (or un-desirable). It works well with add.php from Indexu 3.04 so I will use it for that purpose.
    I would love to use Indexu 5.0.2 for my new site but I am not sure that I want to buy an other lisence. Would you give me a discount?
    BTW I got 7000 categories and also over 80.000 links.

  12. #12
    aladdin1 is offline Active Member
    Join Date
    Feb 2004
    Posts
    455

    Default Search problem

    Hello,

    I have a strange problem (http://4uri.com) if I search in index.php or any page with "Search the entire directory" option the script does not execute properly ( no footer) if I search for "car" in the automobile category with the option "just this category" the script execute properly.
    What could be my problem. How would I give the script more time to execute (I think it just time out after 4 or 5 second)

  13. #13
    dody is offline Administrator
    Join Date
    Aug 2001
    Location
    Indonesia
    Posts
    3,731

    Default

    Try my website http://www.dodygames.com. It has 59491 links and 10474 categories.

    Searching and browse through categories is fast.

    But when i try to 'update number of links' in admin panel, it's quite long and i decide to turn if off.
    www.nicecoder.com
    www.dodyrw.com

  14. #14
    Frank71 is offline Active Member
    Join Date
    Aug 2002
    Location
    Germany
    Posts
    1,180

    Default Nop

    http://www.dodygames.com/ - loading time of index is horrible...

Similar Threads

  1. Replies: 22
    Last Post: 01-17-2005, 08:26 AM
  2. Replies: 5
    Last Post: 08-13-2004, 04:12 PM
  3. Getting lots of header errors
    By shalida in forum v5.x
    Replies: 3
    Last Post: 06-24-2003, 08:30 PM
  4. Adding a link to multiple categories
    By craven in forum v3.2
    Replies: 10
    Last Post: 03-12-2003, 10:27 AM
  5. Adding link to more than one category
    By craven in forum v5.x
    Replies: 2
    Last Post: 03-05-2002, 10:51 PM

Posting Permissions

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