Here is why categories don't always work in INDEXU

[esm]

Here is why categories don't always work in INDEXU

Well, I started to post it here but vB cannot accept a large msg ( or it has been configured that way )

So I posted it here:
http://www.indexuhelp.com/forum/inde...t=msg&goto=884

You really should look at this!

[ezykiwi]

Here is why categories don't always work in INDEXU

Well, I started to post it here but vB cannot accept a large msg ( or it has been configured that way )

So I posted it here:
http://www.indexuhelp.com/forum/inde...t=msg&goto=884

You really should look at this!

Your right ESM, I had to strip all listings of cats from hotlisting, search etc etc.. just because it was totally killing on pageload times... Its a serious issue for anyone with a large amount of cats

[esm]

well, I tinkered with the code to optimize it and it does run faster in v3.2E but anything to do with the categories will be slow relative to the other stuff.

But the new cached static page feature allows the page to load much faster, so that is nice.

I've seen that same coding by dody in other places and I'm going replace it with faster code.

[esm]

I was able to reduce the size of the actual query from over 133,000 characters to just over 41,000 characters.

That alone has to improve performance some. Plus, my way is more straightforward.

Now all have to do is look throughout the v3.2E code to make additional reductions there.

I think v3.2E will be much faster...

[dody]

esm, if you find the way to reduce that query it would be great.
this is the main problem i got so far.

if you have a lot of categories, the query will build ... or .. or ... or .. or .. statement until it reach all lowest level in category tree.

if you have at most 500 categories .. it won't be a problem. But if you have more, the the page load will become long.

[esm]

esm, if you find the way to reduce that query it would be great.

I reduced it by amost 70%.

I can show you lots of places where the code could be tweaked to make it run faster. I'm making the changes as I find them.

Buy a copy of v3.2E and take a look for yourself.

[Frank71]

Ähm, about which problem do you speak and whats abot 3.2E ?
Frank

[esm]

did you read my original post and visit the post at my site describing the problem.

I continue to work on v3.2E just been dealing with an allergy attack for the the 4 days which slowed me down considerably.

[Frank71]

Hm, never I had the problem, but I hope you fell better now

If you know more ways to get indexu faster like killing all user featurs or something like that please let me know

Regards
Frank

[esm]

Removing the user features will not make INDEXU any faster. well, maybe by a nanosecond or two but that would be about it.