Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: any category listing, any plugin, breaks at the blank between words
JimJoe wrote:
Article count doesn’t matter, if the replacement plugin has can trim the empty categories. I can remove the article count.
edit: the nesting is a requirement.
Then try it with stw_category_tree without the count attribute and with killempties="y" and see if that improves performance enough.
Code is topiary
Offline
Re: any category listing, any plugin, breaks at the blank between words
Drops from 14 to 9 seconds. I noticed some of the category connections didn’t import properly. That could be part of the slow down, the database is confused… shrug. In the previous blog, I could connect one entry/article to as many categories as I wanted to. For this site, the average was 3, with some going up to 6 categories for one entry/article.
Offline
Re: any category listing, any plugin, breaks at the blank between words
JimJoe wrote:
Drops from 14 to 9 seconds.
Still not good. What happens if you remove the category list?
In the previous blog, I could connect one entry/article to as many categories as I wanted to. For this site, the average was 3, with some going up to 6 categories for one entry/article.
No doubt about it, category support in Txp is … peculiar. And limited. There’s rss_unlimited_categories, unfortunately no longer supported (although there are patches).
Code is topiary
Offline
Re: any category listing, any plugin, breaks at the blank between words
It goes much faster.
Offline
Re: any category listing, any plugin, breaks at the blank between words
I should mention that the previous blog was slow as well. So I don’t think its a plugin problem so much as a possible database problem.
Offline
Re: any category listing, any plugin, breaks at the blank between words
Here are links to the old and new sites. I don’t see much difference in speed… my Crestar site is the only one that is slow. Could it be due to import from an even earlier blog that didn’t clear out some crud and that has followed into these two ? ( grasping at straws here…)
Offline
Re: any category listing, any plugin, breaks at the blank between words
JimJoe wrote:
It goes much faster.
…
I should mention that the previous blog was slow as well. So I don’t think its a plugin problem so much as a possible database problem.
How much faster? If you get normal performance (page processing time of .3 seconds or less) without the category menu, then the problem is the category menu. If the page is much slower than this even without the category menu, go back to debugging mode and find the slow queries.
But if you think it’s a database problem you should look it over in phpMyAdmin or whatever you use for db management; in particular check over the txp_category and textpattern tables and see that the numbers of rows are what you expect for the number of categories and articles you have.
Code is topiary
Offline
Re: any category listing, any plugin, breaks at the blank between words
It doesn’t get 0.3 seconds to display the page. I’ll check, I think its more like 2-3 seconds.
If there was somehow to add just a third category listing I could select from, that might work instead of unlimited categories.
Offline
Re: any category listing, any plugin, breaks at the blank between words
Well, its 0.35 for queries without plugin.
What puzzles me is that previous blogs/cms were slow to. So I don’t think it is just this plugin. It was slow with Movable Type and with Word Press.
I did do a repair and check db in phpmyadmin. I didn’t notice any difference.
Offline
Re: any category listing, any plugin, breaks at the blank between words
JimJoe wrote:
If there was somehow to add just a third category listing I could select from, that might work instead of unlimited categories.
I don’t know of an in-between solution. While you can use custom fields sort of like categories, you can’t integrate them into standard category lists. So if you need more than 2 categories per article, rss_unlimited_categories is the only solution I know.
Code is topiary
Offline
Re: any category listing, any plugin, breaks at the blank between words
I’ll check into it when I get the chance, busy week.
Offline
Re: any category listing, any plugin, breaks at the blank between words
Okay, I have installed rss_unlimited_categories plugin. The two insert commands that copy over already present articles and categories gives me this error message:
ErrorSQL query: Documentation
INSERT INTO textpattern_category( article_id, category_id )
SELECT t.id, c.id
FROM textpattern t
LEFT JOIN txp_category c ON t.category1 = c.name
WHERE c.type = ‘article’
AND t.category1 != ‘’;
- - Table ‘drivein_txtp.textpattern_category’ doesn’t exist
Offline