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
TOPIC: v 2.2 Pro Slow to show pages
#6826
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 3 Years, 10 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.
#6831
admin (Admin)
Admin
Posts: 4874
graph
User Online Now Click here to see the profile of this user
Re:v 2.2 Pro Slow to show pages 3 Years, 10 Months ago Karma: 61  
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.
#6837
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 3 Years, 10 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.
#6851
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 3 Years, 10 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.
#6852
admin (Admin)
Admin
Posts: 4874
graph
User Online Now Click here to see the profile of this user
Re:v 2.2 Pro Slow to show pages 3 Years, 10 Months ago Karma: 61  
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.
#6868
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 3 Years, 10 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
What are you looking for?
Anti-spam question: How many eyes has a typical person?