OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
How to Improve BooksLibrary Performance? (0 viewing) 
BookLibrary Wishlist
Go to bottom Favoured: 1
TOPIC: How to Improve BooksLibrary Performance?
#14205
Paragp (User)
Senior Boarder
Posts: 41
graphgraph
User Offline Click here to see the profile of this user
How to Improve BooksLibrary Performance? 2 Years ago Karma: 0  
Hello Taras,

What all areas we should look to tune if we want to improve bookslibrary performance?

I do have a VPS server where bookslibrary is hosted and so what all tuning you suggest to do at server level to improve performance.

Also, can we add any additional indexes on other fields of bookslibrary tables which can improve performance without causing any functional breakdown to bookslibrary pro software?

Space is not a concern.

Please suggest. Thanks.

regards,
parag
 
Logged Logged  
  The administrator has disabled public write access.
#14215
Taras (Admin)
Admin
Posts: 2858
graphgraph
User Offline Click here to see the profile of this user
Re:How to Improve BooksLibrary Performance? 2 Years ago Karma: 55  
Hello,

It is not connect with our component. It is question to your host provider.

Thanks,
Taras
OrdaSoft team.
 
Logged Logged  
  The administrator has disabled public write access.
#14363
Paragp (User)
Senior Boarder
Posts: 41
graphgraph
User Offline Click here to see the profile of this user
Re:How to Improve BooksLibrary Performance? 1 Year, 11 Months ago Karma: 0  
Taras,

Let me tell you how is this question relevant to your books library.

Firstly, i am making reference to bookslibrary and not VPS server based objects.

1) Given bookslibrary mysql db design, does bookid have a unique key index? Especially when the product is configured to treat Bookid as unique and not ISBN id as unique?
2) Which all columns would you recommend to have index to improve performance ? books_title, bookid, etc ?

My intention is to ensure that table scans are reduced by indexing any additional important fields which are searched on a regular basis.

Hope my queries are now pointing to bookslibrary software/db and look relevant.

Basically, your products successful implementation and use is our success and yours as well.

thanks,
parag
 
Logged Logged  
  The administrator has disabled public write access.
#14364
admin (Admin)
Admin
Posts: 4861
graph
User Offline Click here to see the profile of this user
Re:How to Improve BooksLibrary Performance? 1 Year, 11 Months ago Karma: 61  
hello Parag,


If you know what is it index - please go to your database - and you will see all indexes what we have in booklibrary

Speed optimization - very big and long process - it depend from every end your site page.

Impossible say about speed - without real page and all sql requests on that page.

so you need do optimization - for every requests

In book library all Primary keys - that ID, all other need check for exactly sql requests

Thanks,
OrdaSoft team
 
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?