OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
v 2.2 Pro Slow to show pages (0 viewing) 

BookLibary Component Support

Go to bottom Favoured: 1

V 2.2 Pro Slow to show pages

libraent (User)
Junior Boarder
Posts: 35
graphgraph
User Offline Click here to see the profile of this user
v 2.2 Pro Slow to show pages 11 Years, 2 Months ago
Karma: 0  
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
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 8230
graph
User Offline Click here to see the profile of this user
Re:v 2.2 Pro Slow to show pages 11 Years, 2 Months ago
Karma: 101  
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
Logged Logged
The administrator has disabled public write access.
libraent (User)
Junior Boarder
Posts: 35
graphgraph
User Offline Click here to see the profile of this user
Re:v 2.2 Pro Slow to show pages 11 Years, 2 Months ago
Karma: 0  
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
Logged Logged
The administrator has disabled public write access.
libraent (User)
Junior Boarder
Posts: 35
graphgraph
User Offline Click here to see the profile of this user
Re:v 2.2 Pro Slow to show pages 11 Years, 2 Months ago
Karma: 0  
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;
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 8230
graph
User Offline Click here to see the profile of this user
Re:v 2.2 Pro Slow to show pages 11 Years, 2 Months ago
Karma: 101  
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
Logged Logged
The administrator has disabled public write access.
libraent (User)
Junior Boarder
Posts: 35
graphgraph
User Offline Click here to see the profile of this user
Re:v 2.2 Pro Slow to show pages 11 Years, 2 Months ago
Karma: 0  
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
Logged Logged
The administrator has disabled public write access.
Go to top
»