OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
How to Improve BooksLibrary Performance? (0 viewing) 

BookLibrary Wishlist

Go to bottom Favoured: 1

How to Improve BooksLibrary Performance?

Paragp (Visitor)
Posts: 0
graphgraph
User Offline
How to Improve BooksLibrary Performance? 9 Years, 7 Months 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.
Taras (User)
Platinum Boarder
Posts: 2857
graphgraph
User Offline Click here to see the profile of this user
Re:How to Improve BooksLibrary Performance? 9 Years, 7 Months ago
Karma: 58  
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.
Paragp (Visitor)
Posts: 0
graphgraph
User Offline
Re:How to Improve BooksLibrary Performance? 9 Years, 7 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.
admin (Admin)
Admin
Posts: 8280
graph
User Offline Click here to see the profile of this user
Re:How to Improve BooksLibrary Performance? 9 Years, 7 Months ago
Karma: 101  
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
»