BookLibary Component Support

I recently upgraded to v 2.2 pro. The main category page is fine, but when you click on a folder to display the books, it is VERY slow to respond. Any ideas as to why? I have tried optimizing the books and category tables.

v2.2 pro
PHP Version 5.2.17
Web Server Apache/2.2.23 (Unix) mod_ssl/2.2.23 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4 PHP/5.2.17
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 2.5.8 Stable [ Ember ] 8-November-2012 14:00 GMT
5.5.28-cll - MySQL Community Server (GPL)

Thanks!

Shane

Hello,

There are some way, first not clear why and where all slow.

First you need check yours site speed. You may do that with help Google WEB page Speed or with help YSlow extension for firefox.

Next need check exactly page, what there are may work slow. Well need check database, may be you have big books numbers - so may be will need optimize select queries.

Also speed may depend from hosting

Thanks,
OrdaSoft team

My server support found the problem, it lies with this query:

Sending data | SELECT blc.id, blc.name, bc.catid, blc.parent_id FROM jo25_booklibrary_main_categories AS blc LEFT |

They modified something in my config to comensate for it and it is now much better! I have awesome support from my host!

Thanks,

Shane

I added more books and everything seemed to slow way down again, here is the response from my host so you may be able to adjust the code or table setup in the future:

That same query (or one very similar to it) is causing big mysql load. I have created indexes on the affected tables, that should speed the query. I have also restarted mysql to kill off any old, hung queries. For your reference the problematic query seems to be:

SELECT blc.id, blc.name, bc.catid, blc.parent_id FROM jo25_booklibrary_main_categories AS blc LEFT JOIN jo25_booklibrary_categories AS bc ON bc.catid=blc.id LEFT JOIN jo25_booklibrary AS b ON bc.bookid = b.bookid WHERE blc.section = 'com_booklibrary' AND blc.id = 55;

Hello Shane,

Thank you but for real do some thing, we need know old script or place where for you all very slow.
So we need see why that slow. Other we may lost some useful features

Thanks,
OrdaSoft team

I don't know what your asking for, it's the book library pro v2.2, your script unmodified. The place where it hangs is after you click on the link, it takes you to the directory of categories, when you click on the category to actually look at the list of books is where it just crawled. Took over a minute to load a single page.

Shane