Adding new link with a lots of categories

[aladdin1]

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?

[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.

[esm]

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.



.

[aladdin1]

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.

[esm]

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

  $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);

[aladdin1]

remove or comment out the following lines in add.php

  $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?

[esm]

http://Heathandhealers.com

should be http://Healthandhealers.com

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



.

[aladdin1]

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.

[aladdin1]

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

[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.

[aladdin1]

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.

[aladdin1]

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)

[dody]

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.

[Frank71]

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