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]

Content visible to License Owner only.

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]

Content visible to License Owner only.

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]

Content visible to License Owner only.

remove or comment out the following lines in add.php

Content visible to License Owner only.

[aladdin1]

Content visible to License Owner only.

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]

Content visible to License Owner only.

should be http://Healthandhealers.com

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



.

[aladdin1]

Content visible to License Owner only.

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]

Content visible to License Owner only.

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